Customer-Query-Track-a-Net-Final-Year-Project.Customer query track .Net final year project explains about customer service software which handles customer feedbacks and submit answers for requests submitted by customers. This project contains system analysis, literature survey, feasibility study, software and hardware requirements, system design and system testing and implementation.

This projects main idea is to provide a software application for organization to receive requests from clients and provide feedback for clients. This application will provide employee performance feedback along with customer satisfaction. For any organization customer feedback system is must for improving their product sales in the market, as soon as organization installs application in the client side customer feedback application starts working there is need to maintain customer information is proper way to maintaining relation with customer. Organization should maintain consistency, reliability and integrity with customers for maintaining long term relation with client. This software application is mostly used by sales and service departments to gainĀ profits.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class customer_CostomerRegistration : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
SqlCommand cmd;
SqlDataReader dr;

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{

}
}

protected void Button1_Click(object sender, EventArgs e)
{
if (Label1.Text == "Username is Available.")
{
if (TextBox1.Text != "" && TextBox2.Text != "")
{
cmd = new SqlCommand("insert into tbl_login(uname,password,gender,email,status,type,cdate)values('"+TextBox1.Text+"','"+TextBox2.Text+"','"+DropDownList1.SelectedItem.ToString()+"','"+TextBox5.Text+"','Activate','Customer',getdate())", con);
con.Open();
int user = cmd.ExecuteNonQuery();
con.Close();
if (user == 1)
{
cmd = new SqlCommand("insert into tbl_contact(uid,country,state,city,contactno,cdate)values(" + Convert.ToInt32(GetUid(TextBox1.Text)) + ",'" + TextBox6.Text + "','" + TextBox7.Text + "','" + TextBox8.Text + "','" + TextBox9.Text + "',getdate())", con);
user = 0;
con.Open();
user = cmd.ExecuteNonQuery();
if (user == 1)
{
string s = "Your Registration successfully completed.";
Response.Redirect("~/customer/CustomerLogin.aspx?rconfirm=" + s.ToString());
}
}
}
}
else
{
Label2.Text = "The Username is already taken.Choose another Name.";
}

}

private int GetUid(string uname)
{
cmd = new SqlCommand("select uid from tbl_login where uname='" + uname.ToString() + "' and type='Customer' ", con);
con.Open();
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
int n = 0;
if (dr.Read())
{
n= Convert.ToInt32(dr[0].ToString());
}
dr.Close();
return n;
}

protected void TextBox1_TextChanged(object sender, EventArgs e)
{
cmd = new SqlCommand("select uname from tbl_login where uname='" + TextBox1.Text + "' and type='Customer' ", con);
con.Open();
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (dr.Read())
{
Label1.Text = "Username is not Available.";
Label1.BackColor = System.Drawing.Color.Red;
TextBox1.Focus();
}
else
{
Label1.Text = "Username is Available.";
Label1.BackColor = System.Drawing.Color.Green;
TextBox2.Focus();
}
dr.Close();
}
}

This application is developed using ASP.Net as front end and Ms-SQL as database server, this system works in distributed architecture model with centralized database used for storing data.SQL connection methodology is used for database connectivity. Based on company interests and services administrator will manage modules of the application.

download Customer Query Track a .Net Final Year Project.