protected void QuoteDetails()
{
string conf;
FetchEmails();
qry = "SELECT * FROM tblConfirmation WHERE ReqId='" + reqid + "'";
SqlDataReader dr = ClassHome.getRecords(qry);
if (dr.Read())
{
conf = dr.GetValue(1).ToString();
Label1.Text = conf;
if (Label1.Text == "Yes")
{
Label2.Visible = false;
Label3.Visible = false;
Label1.Visible = true;
sendEMail.Visible = false;
btnEndchat1.Visible = false;
Label1.Text = "The quote you send was accepted by the customer and sent you following details for appointment";
Panel2.Visible = true;
}
else
{
FetchQuote();
Label2.Visible = true;
Label3.Visible = true;
Panel1.Visible = true;
Label1.Visible = true;
Label1.ForeColor = System.Drawing.Color.Red;
Label1.Text = "Unfortunately!! Your quote was not accepted by the customer.";
}
}
}
protected void FetchAndTransferChat()
{
qry = "SELECT * FROM tblChat WHERE ReqId=" + Request.QueryString["id"];
SqlDataReader dr = ClassHome.getRecords(qry);
if (dr.Read())
{
reqid = dr.GetValue(1).ToString();
sender = dr.GetValue(2).ToString();
chatMsg = dr.GetValue(3).ToString();
customeremail = dr.GetValue(4).ToString();
provideremail = dr.GetValue(5).ToString();
}
else
{
}
qry = "INSERT INTO tblEndedChats (EReqId,ESender,EChatMsg,ECustomerEmail,EProviderEmail) VALUES ('" + reqid + "', '" + sender + "', '" + chatMsg + "', '" + customeremail + "','" + provideremail + "')";
int i = ClassHome.setRecords(qry);
qry = "DELETE FROM tblChat WHERE ReqId='" + reqid + "'";
int p = ClassHome.setRecords(qry);
qry = "DELETE FROM tblCustomerRequest WHERE ReqId = '" + reqid + "'";
int r = ClassHome.setRecords(qry);
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
qry = "SELECT * FROM tblServiceProvider WHERE SPID='" + GridView1.SelectedRow.Cells[1].Text + "'";
SqlDataReader dr = ClassHome.getRecords(qry);
if (dr.Read())
{
txtStore.Text = dr.GetValue(1).ToString();
txtName.Text = dr.GetValue(2).ToString();
txtPhone.Text = dr.GetValue(3).ToString();
txtUserName.Text = dr.GetValue(4).ToString();
txtPassword.Text = dr.GetValue(5).ToString();
txtAddress.Text = dr.GetValue(6).ToString();
txtEmail.Text = dr.GetValue(7).ToString();
ddlProviderType.SelectedValue = dr.GetValue(8).ToString();
txtLic.Text = dr.GetValue(9).ToString();
txtDriverLic.Text = dr.GetValue(10).ToString();
txtReference.Text = dr.GetValue(11).ToString();
btnSubmit.Text = "Update";
btnDelete.Visible = true;
pnlView.Visible = false;
pnlTable.Visible = true;
}
dr.Close();
}
protected void FillGrid()
{
qry = "SELECT RejSPID AS [ID],RejSPStoreName AS [Store Name] , RejSPName AS [Provider Name], RejSPPhone AS [Phone], RejSPAddress AS [Address], RejSPEmail AS [Email], SPType AS [Category], RejSPLic AS [Licence Number] FROM viewRejectedSP";
SqlDataReader dr = ClassHome.getRecords(qry);
GridView1.DataSource = dr;
GridView1.DataBind();
}
protected void FillGrid()
{
qry = "SELECT EmpID AS [ID], EmpName AS [Emp Name], EmpPhone AS [Emp Phone], EmpUserName AS [Emp UserName], EmpPassword AS [Emp Password], EmpAddress AS [Emp Address], EmpEmail AS [Emp Email], EmpType AS [Emp Type] FROM viewEmployee";
SqlDataReader dr = ClassHome.getRecords(qry);
GridView1.DataSource = dr;
GridView1.DataBind();
}
protected void FillGrid()
{
qry = "SELECT CustomerId AS [ID], CustomerName AS [Customer Name], CustomerUName AS [User Name], CustomerPass AS [Password], CustomerEmail AS [Email ID], CustomerPhone AS [Phone Number], CustomerAddress AS [Address] FROM tblCustomer";
SqlDataReader dr = ClassHome.getRecords(qry);
GridView1.DataSource = dr;
GridView1.DataBind();
}
protected void FillGrid()
{
qry = "SELECT SPID AS [ID],SPStoreName AS [Store Name] , SPName AS [Provider Name], SPPhone AS [Phone], SPUserName AS [UserName], SPPassword AS [Password], SPAddress AS [Address], SPEmail AS [Email], SPType AS [Category], SPLic AS [Licence Number], SPDriverLic AS [Driver's Lic], SPReferences AS [References] FROM viewServiceProvider";
SqlDataReader dr = ClassHome.getRecords(qry);
GridView1.DataSource = dr;
GridView1.DataBind();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
qry = "SELECT CustomerId AS [ID], CustomerName AS [Customer Name], CustomerUName AS [User Name], CustomerPass AS [Password], CustomerEmail AS [Email ID], CustomerPhone AS [Phone Number], CustomerAddress AS [Address] FROM tblCustomer WHERE CustomerPhone LIKE '" + txtSearchCompany.Text + "%'";
SqlDataReader dr = ClassHome.getRecords(qry);
GridView1.DataSource = dr;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
FillGrid();
qry = "SELECT DISTINCT([SPType]) FROM[tblServiceProviderType]";
SqlDataReader dr = ClassHome.getRecords(qry);
ddlSearchCategory.DataSource = dr;
ddlSearchCategory.DataBind();
ddlSearchCategory.Items.Insert(0, "-- select --");
}
}
/* public void FillGrid()
* {
* SqlConnection con = new SqlConnection(@"Data Source = (LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\HomeSol.mdf;Integrated Security=True");
* qry = "SELECT * FROM tblChat WHERE ReqId=" + Request.QueryString["id"];
* SqlDataReader dr = ClassHome.getRecords(qry);
* GridView1.DataSource = dr;
* GridView1.DataBind();
* }*/
public void FetchEmails()
{
qry = "SELECT * FROM tblChat WHERE ReqId=" + Request.QueryString["id"];
SqlDataReader dr = ClassHome.getRecords(qry);
if (dr.Read())
{
reqid = dr.GetValue(1).ToString();
customeremail = dr.GetValue(4).ToString();
provideremail = dr.GetValue(5).ToString();
Label1.Text = customeremail;
Label2.Text = provideremail;
}
}
protected void FetchQuote()
{
FetchEmails();
qry = "SELECT * FROM tblQuote WHERE ReqId=" + reqid;
SqlDataReader dr = ClassHome.getRecords(qry);
if (dr.Read())
{
quoteid = dr.GetValue(0).ToString();
quote = dr.GetValue(1).ToString();
Label2.Text = quote;
lblQuoteId.Text = quoteid;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["utype"].ToString() == "Reception")
{
Response.Redirect("EmployeeDash.aspx");
}
qry = "SELECT DISTINCT([SPType]) FROM[tblServiceProviderType]";
SqlDataReader dr = ClassHome.getRecords(qry);
ddlSearchCategory.DataSource = dr;
ddlSearchCategory.DataBind();
ddlSearchCategory.Items.Insert(0, "-- select --");
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (ddlSearchCategory.SelectedIndex == 0)
{
qry = "SELECT RejSPID AS [ID], RejSPStoreName AS [Store Name] , RejSPName AS [Provider Name], RejSPPhone AS [Phone], RejSPAddress AS [Address], RejSPEmail AS [Email], SPType AS [Category], RejSPLic AS [Licence Number] FROM viewRejectedSP WHERE RejSPStoreName LIKE '" + txtSearchCompany.Text + "%'";
}
else
{
qry = "SELECT RejSPID AS [ID], RejSPStoreName AS [Store Name] , RejSPName AS [Provider Name], RejSPPhone AS [Phone], RejSPAddress AS [Address], RejSPEmail AS [Email], SPType AS [Category], RejSPLic AS [Licence Number] FROM viewRejectedSP WHERE RejSPStoreName LIKE '" + txtSearchCompany.Text + "%' AND SPType='" + ddlSearchCategory.SelectedValue + "'";
}
SqlDataReader dr = ClassHome.getRecords(qry);
GridView1.DataSource = dr;
GridView1.DataBind();
}
protected void btnLogin_Click(object sender, EventArgs e)
{
Session["uname"] = txtName.Text;
query = "SELECT * FROM viewEmployee WHERE EmpUserName='******' AND EmpPassword='******'";
SqlDataReader dr = ClassHome.getRecords(query);
if (dr.Read())
{
Session["utype"] = dr.GetValue(8).ToString();
Response.Redirect("EmployeeDash.aspx");
}
else
{
lblMsg.Text = "Invalid UserName or Password";
}
dr.Close();
}
public void FetchEmails()
{
Label lbl1 = DataList1.Items[0].FindControl("lblRequest") as Label;
chatMsg = lbl1.Text;
Label lbl = DataList1.Items[0].FindControl("lblReqId") as Label;
string lblreqid = lbl.Text;
qry = "SELECT * FROM tblChat WHERE ReqId=" + lblreqid;
SqlDataReader dr = ClassHome.getRecords(qry);
if (dr.Read())
{
reqid = dr.GetValue(1).ToString();
sender1 = dr.GetValue(2).ToString();
customeremail = dr.GetValue(4).ToString();
provideremail = dr.GetValue(5).ToString();
}
}
protected void sendEMail_Click1(object sender, EventArgs e)
{
Label lbl = DataList1.Items[0].FindControl("lblEmail") as Label;
string lbltext = lbl.Text;
Label lbl1 = DataList1.Items[0].FindControl("lblName") as Label;
string lblname = lbl1.Text;
Label lbl2 = DataList1.Items[0].FindControl("lblStoreName") as Label;
string lblstore = lbl2.Text;
Label lbl3 = DataList1.Items[0].FindControl("lblPhone") as Label;
string lblphone = lbl3.Text;
Label lbl4 = DataList1.Items[0].FindControl("lblAddress") as Label;
string lbladdress = lbl4.Text;
NetworkCredential loginInfo = new NetworkCredential("*****@*****.**", "homesolutions");
MailMessage msg = new MailMessage();
string text = "Hello!! " + lblname + " You got one new request from customer:\n" + txtContent.Text +
@"<html> <body> <br><hr/> Thanks and Regards <br> <b>Home Solutions and Co. </b></body> </html> ";
msg.From = new MailAddress("*****@*****.**");
msg.To.Add(new MailAddress(lbltext)); //the email id where you need to send email.
msg.Subject = "Update on your application in Home Solutions";
msg.Body = text;
msg.IsBodyHtml = true;
SmtpClient client = new SmtpClient("smtp.gmail.com", 587);
client.EnableSsl = true;
client.UseDefaultCredentials = false;
client.Credentials = loginInfo;
client.Send(msg);
InsertDetails();
string reqid, msg1;
qry = "SELECT * FROM tblCustomerRequest WHERE CustPhone = '" + custphone + "'";
SqlDataReader dr = ClassHome.getRecords(qry);
if (dr.Read())
{
reqid = dr.GetValue(0).ToString();
msg1 = dr.GetValue(5).ToString();
qry = "INSERT INTO tblChat (ReqId,Sender,ChatMsg,CustomerEmail,ProviderEmail) VALUES ('" + reqid + "','" + custname + "','" + msg1 + "','" + custemail + "', '" + lbltext + "')";
int p = ClassHome.setRecords(qry);
}
Response.Redirect("Dashboard.aspx");
}
protected void GridView1_SelectedIndexChanged1(object sender, EventArgs e)
{
qry = "SELECT * FROM viewPreServiceProvider WHERE PreSPID='" + GridView1.SelectedRow.Cells[1].Text + "'";
SqlDataReader dr = ClassHome.getRecords(qry);
if (dr.Read())
{
lblStoreName.Text = dr.GetValue(1).ToString();
lblName.Text = dr.GetValue(2).ToString();
lblPhone.Text = dr.GetValue(3).ToString();
lblEmail.Text = dr.GetValue(5).ToString();
lblAddress.Text = dr.GetValue(4).ToString();
lblLic.Text = dr.GetValue(7).ToString();
lblType.Text = dr.GetValue(10).ToString();
lblTypeID.Text = dr.GetValue(6).ToString();
lblDriverLic.Text = dr.GetValue(8).ToString();
lblReferences.Text = dr.GetValue(9).ToString();
}
dr.Close();
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
qry = "SELECT * FROM tblCustomer WHERE CustomerId='" + GridView1.SelectedRow.Cells[1].Text + "'";
SqlDataReader dr = ClassHome.getRecords(qry);
if (dr.Read())
{
txtName.Text = dr.GetValue(1).ToString();
txtUserName.Text = dr.GetValue(2).ToString();
txtPassword.Text = dr.GetValue(3).ToString();
txtEmail.Text = dr.GetValue(4).ToString();
txtPhone.Text = dr.GetValue(5).ToString();
txtAddress.Text = dr.GetValue(6).ToString();
btnSubmit.Text = "Update";
btnDelete.Visible = true;
pnlView.Visible = false;
pnlTable.Visible = true;
}
dr.Close();
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
string ProviderStore, CustomerName, CustomerPhone, ProviderPhone, CustomerAddress, CustomerQuery, QuoteAmount;
qry = "SELECT * FROM tblAppointment WHERE ApptId=" + Request.QueryString["id"];
SqlDataReader dr = ClassHome.getRecords(qry);
if (dr.Read())
{
ProviderStore = dr.GetValue(1).ToString();
CustomerName = dr.GetValue(2).ToString();
CustomerPhone = dr.GetValue(3).ToString();
ProviderPhone = dr.GetValue(4).ToString();
CustomerAddress = dr.GetValue(5).ToString();
CustomerQuery = dr.GetValue(6).ToString();
QuoteAmount = dr.GetValue(7).ToString();
qry = "INSERT INTO tblComplete (ProviderStore,CustomerName,CustomerPhone,ProviderPhone,CustomerAddress,CustomerQuery,QuoteAmount) VALUES ('" + ProviderStore + "','" + CustomerName + "','" + CustomerPhone + "','" + ProviderPhone + "','" + CustomerAddress + "','" + CustomerQuery + "','" + QuoteAmount + "')";
int i = ClassHome.setRecords(qry);
qry = "DELETE FROM tblAppointment WHERE ApptId=" + Request.QueryString["id"];
int p = ClassHome.setRecords(qry);
}
Response.Redirect("CompletedRequests.aspx");
}
protected void FetchDetails()
{
Label lbl1 = DataList1.Items[0].FindControl("lblProviderPhone") as Label;
providerphone = lbl1.Text;
Label lbl2 = DataList1.Items[0].FindControl("lblStoreName") as Label;
providerstore = lbl2.Text;
Label lbl4 = DataList1.Items[0].FindControl("lblCustomerQuery") as Label;
customerquery = lbl4.Text;
Label lbl5 = DataList1.Items[0].FindControl("lblQuote") as Label;
quote = lbl5.Text;
qry = "SELECT * FROM tblServiceProvider WHERE SPPhone=" + providerphone;
SqlDataReader dr = ClassHome.getRecords(qry);
if (dr.Read())
{
provideremail = dr.GetValue(7).ToString();
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string password = txtPwd.Text;
string enc = encryption(password);
query = "SELECT * FROM tblCustomer WHERE CustomerUName='" + txtName.Text + "' AND CustomerPass='******'";
SqlDataReader dr = ClassHome.getRecords(query);
if (dr.Read())
{
Session["CustName"] = dr.GetValue(1).ToString();
Session["CustEmail"] = dr.GetValue(4).ToString();
Session["CustPhone"] = dr.GetValue(5).ToString();
Session["CustAddress"] = dr.GetValue(6).ToString();
Session["uname"] = txtName.Text;
Response.Redirect("Dashboard.aspx");
}
else
{
lblMsg.Text = "Invalid UserName or Password";
}
dr.Close();
}
protected void CheckQuote()
{
string quote;
qry = "SELECT * FROM tblQuote where Reqid =" + Request.QueryString["id"];
SqlDataReader dr = ClassHome.getRecords(qry);
if (dr.Read())
{
quote = dr.GetValue(1).ToString();
lblQuote.Text = "Provider Sent you the quote: $" + quote;
lblQuote.Visible = true;
}
if (lblQuote.Text == "Label")
{
}
else
{
lblQuote.Visible = true;
Panel1.Visible = false;
Panel3.Visible = true;
}
}
protected void btnSendAppt_Click(object sender, EventArgs e)
{
string CustomerName, CustomerPhone, ProviderName, ProviderPhone, CustomerAddress, CustomerQuery;
FetchQuote();
qry = "SELECT * FROM tblCustomerRequest WHERE ReqId=" + reqid;
SqlDataReader dr = ClassHome.getRecords(qry);
if (dr.Read())
{
CustomerName = dr.GetValue(1).ToString();
CustomerPhone = dr.GetValue(2).ToString();
ProviderName = dr.GetValue(8).ToString();
ProviderPhone = dr.GetValue(10).ToString();
CustomerAddress = dr.GetValue(4).ToString();
CustomerQuery = dr.GetValue(5).ToString();
qry = "INSERT INTO tblAppointment (ProviderStore,CustomerName,CustomerPhone,ProviderPhone,CustomerAddress,CustomerQuery,QuoteAmount,Date,TIME) VALUES('" + ProviderName + "','" + CustomerName + "','" + CustomerPhone + "','" + ProviderPhone + "','" + CustomerAddress + "','" + CustomerQuery + "','" + Label2.Text + "','" + txtApp.Text + "','" + txtApptime.Text + "')";
int i = ClassHome.setRecords(qry);
}
qry = "DELETE FROM tblCustomerRequest WHERE ReqId=" + reqid;
int r = ClassHome.setRecords(qry);
Response.Redirect("ProviderAppointmentDetails.aspx");
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string password = txtPass.Text;
string enc = encryption(password);
query = "SELECT * FROM tblServiceProvider WHERE SPUserName='******' AND SPPassword='******'";
SqlDataReader dr = ClassHome.getRecords(query);
if (dr.Read())
{
Session["ProviderStore"] = dr.GetValue(1).ToString();
Session["ProviderName"] = dr.GetValue(2).ToString();
Session["ProviderEmail"] = dr.GetValue(7).ToString();
Session["ProviderPhone"] = dr.GetValue(3).ToString();
Session["ProviderAddress"] = dr.GetValue(6).ToString();
Session["uname"] = txtName.Text;
Response.Redirect("ServiceProviderDash.aspx");
}
else
{
lblMsg.Text = "Invalid UserName or Password";
}
dr.Close();
}