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 btnRating_Click(object sender, EventArgs e) { FetchDetails(); SqlConnection con = new SqlConnection(@"Data Source = (LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\HomeSol.mdf;Integrated Security=True"); qry = "INSERT INTO tblrating (rating, review, StoreName, CustomerName) VALUES (@ratingvalue, @review,@provideremail,@custemail )"; SqlCommand cmd = new SqlCommand(qry); SqlDataAdapter sda = new SqlDataAdapter(); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@ratingvalue", Rating1.CurrentRating.ToString()); cmd.Parameters.AddWithValue("@review", txtreview.Text); cmd.Parameters.AddWithValue("@provideremail", provideremail); cmd.Parameters.AddWithValue("@custemail", customeremail); cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); qry = "INSERT INTO tblCustomerCompletion (ProviderStore,CustomerName,ProviderPhone,CustomerQuery,QuoteAmount) VALUES ('" + providerstore + "','" + customername + "','" + providerphone + "','" + customerquery + "','" + quote + "')"; int i = ClassHome.setRecords(qry); Label lbl6 = DataList1.Items[0].FindControl("lblId") as Label; string id = lbl6.Text; qry = "DELETE FROM tblComplete WHERE Id=" + id; int p = ClassHome.setRecords(qry); Response.Redirect("Dashboard.aspx"); }
protected void btnDelete_Click(object sender, EventArgs e) { qry = "DELETE FROM tblCustomer WHERE CustomerId='" + GridView1.SelectedRow.Cells[1].Text + "'"; int i = ClassHome.setRecords(qry); AllClear(); lblMsg.Text = "Record DELETED successfully."; }
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 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(); }
/*public void FillGrid() * { * Label lbl = DataList1.Items[0].FindControl("lblReqId") as Label; * string lblreqid = lbl.Text; * SqlConnection con = new SqlConnection(@"Data Source = (LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\HomeSol.mdf;Integrated Security=True"); * qry = "SELECT * FROM tblChat WHERE ReqId=" + lblreqid; * SqlDataReader dr = ClassHome.getRecords(qry); * GridView1.DataSource = dr; * GridView1.DataBind(); * } */ protected void sendEMail_Click(object sender, EventArgs e) { Label lbl = DataList1.Items[0].FindControl("lblReqId") as Label; string lblreqid = lbl.Text; qry = "INSERT INTO tblChat (ReqId,Sender,ChatMsg,CustomerEmail,ProviderEmail) VALUES ('" + lblreqid + "','" + providername + "','" + txtContent.Text + "','" + customeremail + "', '" + provideremail + "')"; int i = ClassHome.setRecords(qry); }
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 btnLogin_Click(object sender, EventArgs e) { qry = "INSERT INTO tblPreServiceProvider (PreSPStoreName ,PreSPName,PreSPPhone,PreSPAddress,PreSPEmail,SPTypeId, PreSPLic, PreDriverLic, PreReferences) VALUES ('" + txtStore.Text + "', '" + txtName.Text + "','" + txtPhone.Text + "','" + txtAddress.Text + "','" + txtEmail.Text + "','" + ddlProviderType.SelectedValue + "','" + txtLic.Text + "','" + txtDriverLic.Text + "','" + txtReferences.Text + "')"; int i = ClassHome.setRecords(qry); AllClear(); lblMsg.ForeColor = System.Drawing.Color.White; Response.Redirect("AfterSubmit.aspx"); }
protected void btnLogin_Click(object sender, EventArgs e) { string password = txtPassword.Text; string enc = encryption(password); qry = "INSERT INTO tblCustomer (CustomerName ,CustomerUName,CustomerPass,CustomerEmail,CustomerPhone,CustomerAddress) VALUES ('" + txtName.Text + "', '" + txtUserName.Text + "','" + enc + "','" + txtEmail.Text + "','" + txtPhone.Text + "','" + txtAddress.Text + "')"; int i = ClassHome.setRecords(qry); Response.Redirect("CustomerLogin.aspx"); }
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 btnAbort_Click(object sender, EventArgs e) { FetchEmails(); qry = "INSERT INTO tblEndedChats (EReqId,ESender,EChatMsg,ECustomerEmail,EProviderEmail) VALUES ('" + reqid + "', '" + sender1 + "', '" + 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); Response.Redirect("ServiceProviderDash.aspx"); }
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 btnSubmit_Click(object sender, EventArgs e) { if (btnSubmit.Text == "Submit") { qry = "INSERT INTO tblEmployee (EmpName,EmpPhone,EmpUserName,EmpPassword,EmpAddress,EmpEmail,EmpTypeID) VALUES ('" + txtName.Text + "','" + txtPhone.Text + "','" + txtUserName.Text + "','" + txtPassword.Text + "','" + txtAddress.Text + "','" + txtEmail.Text + "','" + ddlEmpType.SelectedValue + "')"; } else { qry = "UPDATE tblEmployee SET EmpName='" + txtName.Text + "', EmpPhone='" + txtPhone.Text + "', EmpUserName='******', EmpPassword='******', EmpAddress='" + txtAddress.Text + "', EmpEmail='" + txtEmail.Text + "', EmpTypeID='" + ddlEmpType.SelectedValue + "' WHERE EmpID='" + GridView1.SelectedRow.Cells[1].Text + "'"; } int i = ClassHome.setRecords(qry); AllClear(); lblMsg.Text = "Record submitted successfully."; }
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 btnNo_Click(object sender, EventArgs e) { FetchEmails(); string flag = "No"; qry = "DELETE FROM tblConfirmation WHERE ReqId='" + reqid + "'"; int i = ClassHome.setRecords(qry); qry = "INSERT INTO tblConfirmation (Confirmation,ReqId) VALUES ('" + flag + "','" + reqid + "')"; int p = ClassHome.setRecords(qry); Panel1.Visible = true; Panel3.Visible = false; lblQuote.Visible = false; }
public void InsertDetails() { 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; qry = "INSERT INTO tblCustomerRequest (CustName, CustPhone, CustEmail, CustAddress, RequestDetails, ProviderName, ProviderEmail, ProviderStoreName, ProviderAddress, ProviderPhone) VALUES ('" + custname + "','" + custphone + "','" + custemail + "','" + custaddress + "','" + txtContent.Text + "','" + lblname + "','" + lbltext + "','" + lblstore + "','" + lbladdress + "','" + lblphone + "')"; int i = ClassHome.setRecords(qry); }
protected void btnYes_Click(object sender, EventArgs e) { FetchEmails(); string flag = "Yes"; qry = "DELETE FROM tblConfirmation WHERE ReqId='" + reqid + "'"; int i = ClassHome.setRecords(qry); qry = "INSERT INTO tblConfirmation (Confirmation,ReqId) VALUES ('" + flag + "','" + reqid + "')"; int p = ClassHome.setRecords(qry); Panel1.Visible = true; Panel3.Visible = false; lblQuote.Visible = false; Label3.Text = "Accept the quote and send an appointment details:"; }
protected void btnSubmit_Click(object sender, EventArgs e) { string password = txtPassword.Text; string enc = encryption(password); if (btnSubmit.Text == "Submit") { qry = "INSERT INTO tblServiceProvider (SPStoreName ,SPName,SPPhone,SPUserName,SPPassword,SPAddress,SPEmail,SPTypeId, SPLic) VALUES ('" + txtStore.Text + "', '" + txtName.Text + "','" + txtPhone.Text + "','" + txtUserName.Text + "','" + enc + "','" + txtAddress.Text + "','" + txtEmail.Text + "','" + ddlProviderType.SelectedValue + "','" + txtLic.Text + "')"; } else { qry = "UPDATE tblServiceProvider SET SPStoreName='" + txtStore.Text + "', SPName='" + txtName.Text + "', SPPhone='" + txtPhone.Text + "', SPUserName='******', SPPassword='******', SPAddress='" + txtAddress.Text + "', SPEmail='" + txtEmail.Text + "', SPTypeId='" + ddlProviderType.SelectedValue + "', SPLic = '" + txtLic.Text + "' WHERE SPID='" + GridView1.SelectedRow.Cells[1].Text + "'"; } int i = ClassHome.setRecords(qry); AllClear(); lblMsg.Text = "Record submitted successfully."; }
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(); }
protected void btnSubmit_Click(object sender, EventArgs e) { string password = txtPassword.Text; string enc = encryption(password); if (btnSubmit.Text == "Submit") { qry = "INSERT INTO tblCustomer (CustomerName ,CustomerUName, CustomerPass, CustomerEmail ,CustomerPhone, CustomerAddress) VALUES ('" + txtName.Text + "','" + txtUserName.Text + "','" + enc + "','" + txtEmail.Text + "','" + txtPhone.Text + "', '" + txtAddress.Text + "')"; } else { qry = "UPDATE tblCustomer SET CustomerName='" + txtName.Text + "', CustomerPhone='" + txtPhone.Text + "', CustomerUName='" + txtUserName.Text + "', CustomerPass='******', CustomerAddress='" + txtAddress.Text + "', CustomerEmail='" + txtEmail.Text + "' WHERE CustomerId='" + GridView1.SelectedRow.Cells[1].Text + "'"; } int i = ClassHome.setRecords(qry); AllClear(); lblMsg.Text = "Record submitted successfully."; }
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"); }
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 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 btnApprove1_Click(object sender, EventArgs e) { string password = txtPassword.Text; string enc = encryption(password); int flag = 0; if (flag == 0) { qry = "INSERT INTO tblServiceProvider (SPStoreName ,SPName,SPPhone,SPUserName,SPPassword,SPAddress,SPEmail,SPTypeId, SPLic,SPDriverLic,SPReferences) VALUES ('" + lblStoreName.Text + "', '" + lblName.Text + "','" + lblPhone.Text + "','" + txtUserName.Text + "','" + enc + "','" + lblAddress.Text + "','" + lblEmail.Text + "','" + lblTypeID.Text + "','" + lblLic.Text + "','" + lblDriverLic.Text + "','" + lblReferences.Text + "')"; int i = ClassHome.setRecords(qry); qry1 = "DELETE FROM tblPreServiceProvider WHERE PreSPID='" + GridView1.SelectedRow.Cells[1].Text + "'"; int i1 = ClassHome.setRecords(qry1); flag = 1; } else { } if (flag == 1) { string text = "Hello!!" + lblStoreName.Text + " You have been successfully approved for the home solution signup."; string text1 = "@ <html><body><p> Congratulations on your approval.</p><p> Now customer can see your all information on their portal.</p>" + "<p> We have attached the username and password to this email </p><hr><b> Your User name is:</b></body></html>" + txtUserName.Text; string text2 = @"<html><body><b>And Your password is:</b></body></html>"; string text3 = @" <html> <body> <br><hr/><br> Thanks and Regards<br><b>Home Solutions and Co. </b></body> </html> "; NetworkCredential loginInfo = new NetworkCredential("*****@*****.**", "homesolutions"); MailMessage msg = new MailMessage(); msg.From = new MailAddress("*****@*****.**"); msg.To.Add(new MailAddress(lblEmail.Text)); //the email id where you need to send email. msg.Subject = "Your Login Credentials for Home Solutions"; msg.Body = text + text1 + text2 + txtPassword.Text + text3;; msg.IsBodyHtml = true; SmtpClient client = new SmtpClient("smtp.gmail.com", 587); client.EnableSsl = true; client.UseDefaultCredentials = false; client.Credentials = loginInfo; client.Send(msg); //for sending email ends here Response.Redirect("PendingApprovals.aspx"); } }