private void lesser(DateTime date, string desc, string claimid) { string subject = "Expenses Claim Acknowledgement"; string body = "Dear\t" + name.Text + ",<br /><br />\n\n The below Claim request has been forwarded to your approver <br />\n\n Claim ID: \t" + claimid + "<br />\nClaim Date: \t" + date + "<br >\n Type: \t" + ClaimDropDown.SelectedValue + "<br />\n Description: \t" + desc + "<br />\n Amount: \t" + txtBillAmount.Text + "<br />\n Status: \tPending\n\n" + "\n\n<br /><br />Note :\tPlease Mention ClaimID in all Communications with us regarding the Claim" + "<br />Please click here to <a href=\"http://192.168.0.105/Login.aspx\" > login</a>" + "\n\n\n<br /><br />Thanks And Regards\n<br />ERS Team<br />\nSNPL"; sendMailToEmployee(subject, body, mailid); alertmod.Style.Add("background-color", "#d7ecc6"); alert.Style.Add("background-color", "#d7ecc6"); Label5.ForeColor = System.Drawing.ColorTranslator.FromHtml("green"); Label6.ForeColor = System.Drawing.ColorTranslator.FromHtml("black"); Label5.Text = "Success!"; Label6.Text = "Your claim details are submitted"; alert.Visible = true; // ClientScript.RegisterStartupScript(GetType(), "alert", "alert(' Your claim details are submitted');", true); TextBox2.Text = string.Empty; txtBillAmount.Text = string.Empty; txtRemarks.Text = string.Empty; //FileUpload1.FileContent.Flush(); currencydropdown.ClearSelection(); ClaimDropDown.ClearSelection(); Label2.Text = string.Empty; Label9.Text = string.Empty; }
private void greater(DateTime date, string desc, string claimid) { SqlConnection con1 = new SqlConnection(cs); con1.Open(); SqlCommand myCommand = new SqlCommand("update ERSClaim set ERSApproverID='SNPL-HYD-2016' where ERSEmployeeID='" + Session["SessionEmployeeID"].ToString() + "'", con1); myCommand.ExecuteNonQuery(); con1.Close(); string subject = "Expenses Claim Acknowledgement"; string body = "Dear \t" + name.Text + ",<br /><br />\n\n The below Claim request has been forwarded to your approver. <br />\n\n Claim ID: \t" + claimid + "<br />\n Date :\t" + date + "<br >\n Type :\t" + ClaimDropDown.SelectedValue + "<br />\n Description: \t" + desc + "<br />\n Amount :\t" + txtBillAmount.Text + "<br />\n Status: \tPending\n\n" + "\n\n<br /><br />Note :\tPlease Mention ClaimID in all Communications with us regarding the Claim" + "<br />Please click here to <a href=\"http://192.168.0.105/Login.aspx\" > login</a>" + "\n\n\n<br /><br />Thanks And Regards\n<br />ERS Team\n<br />SNPL"; sendMailToEmployee(subject, body, mailid); alertmod.Style.Add("background-color", "#d7ecc6"); alert.Style.Add("background-color", "#d7ecc6"); Label5.ForeColor = System.Drawing.ColorTranslator.FromHtml("green"); Label6.ForeColor = System.Drawing.ColorTranslator.FromHtml("black"); Label5.Text = "Success!"; Label6.Text = "your Claim Eligiblity Exceeded, Forwarded To Next Level"; alert.Visible = true; // ClientScript.RegisterStartupScript(GetType(), "alert", "alert(' your Claim Eligiblity Exceeded, Forwarded To Next Level');", true); TextBox2.Text = string.Empty; txtBillAmount.Text = string.Empty; txtRemarks.Text = string.Empty; //FileUpload1.FileContent.Flush(); Label2.Text = string.Empty; Label9.Text = string.Empty; ClaimDropDown.ClearSelection(); currencydropdown.ClearSelection(); }