protected void Page_Load(object sender, EventArgs e) { string quoids = Session["quoids"].ToString(); DataTable dt = new QuotationLogic().selectForPrint(quoids); Repeater1.DataSource = dt; Repeater1.DataBind(); int c = 0; String s = ""; foreach (DataRow row in dt.Rows) { if (c == 0) { s = row["CustomerName"].ToString(); c++; } else { if (!row["CustomerName"].ToString().Equals(s)) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Multiple customer can not have same quotation.')", true); Response.Redirect("QuotationList.aspx"); } c++; } } Label5.Text = s; Label6.Text = dt.Rows[0]["Address"].ToString(); Label7.Text = dt.Rows[0]["Phone"].ToString(); Label8.Text = dt.Rows[0]["Email"].ToString(); Label9.Text = DateTime.Today.ToString("dd/MM/yyyy"); }
public TransactionController() { _enquiryLogic = new EnquiryLogic(); _quotationLogic = new QuotationLogic(); _salesOrderLogic = new SalesOrderLogic(); _deliveryNoteLogic = new DeliveryNoteLogic(); }
protected void Button1_Click(object sender, EventArgs e) { Label2.Visible = false; //ScriptManager.RegisterClientScriptBlock(this , this.GetType(), "alertMessage", "alert('All selected quotations shoud be of same customer.')", true); string ans = ""; foreach (RepeaterItem ri in Repeater1.Items) { CheckBox cb = (CheckBox)ri.FindControl("Checkbox1"); if (cb.Checked) { int quoid = Convert.ToInt32(((Label)ri.FindControl("Label1")).Text); ans += quoid + ","; } } if (ans.Length > 1) { ans = ans.Substring(0, ans.Length - 1); Session["quoids"] = ans; DataTable dt = new QuotationLogic().selectForPrint(ans); // Repeater1.DataSource = dt; // Repeater1.DataBind(); int c = 0; String s = ""; foreach (DataRow row in dt.Rows) { if (c == 0) { s = row["CustomerName"].ToString(); c++; } else { if (!row["CustomerName"].ToString().Equals(s)) { Label2.Visible = true; break; // Response.Redirect("QuotationList.aspx"); } else { Label2.Visible = false; } c++; } } if (Label2.Visible == false) { Response.Redirect("PrintQuotation.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { EmployeeLogic el = new EmployeeLogic(); Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"])); if (!IsPostBack) { if (e2.Designation.Equals("MANAGING DIRECTOR") || e2.Designation.Equals("CHAIRMAN") || e2.Designation.Equals("COMERCIAL MANAGER") || e2.Designation.Equals("COMERCIAL EMPLOYEE") || e2.Designation.Equals("MARKETING MANAGER") || e2.Designation.Equals("MARKETING EMPLOYEE") || e2.Designation.Equals("PRODUCTION MANAGER") || e2.Designation.Equals("PRODUCTION EMPLOYEE")) { QuotationLogic QL = new QuotationLogic(); DataTable dt = QL.SelectAllJoined(); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } CustomerLogic cl = new CustomerLogic(); DataTable dt1 = cl.SelectAll(); dt1.Rows.Add(0, "All Customer", null, null, null, null, null, null, null, null, null); dt1.DefaultView.Sort = "CustomerID"; DropDownList1.DataSource = dt1; DropDownList1.DataTextField = "Name"; DropDownList1.DataValueField = "CustomerID"; DropDownList1.DataBind(); DropDownList1.SelectedItem.Text = "All Customer"; ProductLogic pl = new ProductLogic(); DataTable dt2 = pl.SelectAll(); dt2.Rows.Add(0, "All Product", null, null, null, null, null, null, null, null); dt2.DefaultView.Sort = "ProductID"; DropDownList2.DataSource = dt2; DropDownList2.DataTextField = "Name"; DropDownList2.DataValueField = "ProductID"; DropDownList2.DataBind(); DropDownList2.SelectedItem.Text = "All Product"; } else { Response.Redirect("Access.aspx"); } } }
protected void LinkButton1_Command(object sender, CommandEventArgs e) { EmployeeLogic el = new EmployeeLogic(); Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"])); if (e2.Designation.Equals("MANAGING DIRECTOR") || e2.Designation.Equals("CHAIRMAN") || e2.Designation.Equals("COMERCIAL MANAGER") || e2.Designation.Equals("COMERCIAL EMPLOYEE")) { QuotationLogic ql = new QuotationLogic(); Quotation q1 = ql.SelectByID(Convert.ToInt32(e.CommandArgument)); if (q1 != null) { ql.Delete(q1.QuotationID); Response.Redirect("QuotationList.aspx"); } } else { Response.Redirect("Access.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { EmployeeLogic el = new EmployeeLogic(); Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"])); if (e2.Designation.Equals("MANAGING DIRECTOR") || e2.Designation.Equals("CHAIRMAN") || e2.Designation.Equals("COMERCIAL MANAGER") || e2.Designation.Equals("COMERCIAL EMPLOYEE")) { if (!IsPostBack) { ProductLogic pl = new ProductLogic(); DropDownList1.DataSource = pl.SelectAll(); DropDownList1.DataTextField = "Name"; DropDownList1.DataValueField = "ProductID"; DropDownList1.DataBind(); QuotationLogic ql = new QuotationLogic(); Quotation q1 = ql.SelectByID(Convert.ToInt32(Request.QueryString["id"])); if (q1.QuotationID > 0) { Product p1 = pl.SelectByProductID(q1.ProductID); DropDownList1.SelectedItem.Value = p1.ProductID.ToString(); TextBox1.Text = q1.MOQ.ToString(); TextBox2.Text = q1.Rate.ToString(); TextBox3.Text = q1.CreateDate.ToString("dd/MM/yyyy"); TextBox4.Text = q1.Status; TextBox5.Text = q1.Remarks; TextBox6.Text = q1.TermsConditions; } else { TextBox3.Text = DateTime.Now.ToString("dd/MM/yyyy"); } } } else { Response.Redirect("Access.aspx"); } }
protected void Button2_Click(object sender, EventArgs e) { EmployeeLogic el = new EmployeeLogic(); Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"])); if (e2.Designation.Equals("MANAGING DIRECTOR") || e2.Designation.Equals("CHAIRMAN") || e2.Designation.Equals("COMERCIAL MANAGER") || e2.Designation.Equals("COMERCIAL EMPLOYEE")) { QuotationLogic ql = new QuotationLogic(); DateTime d1 = new DateTime(); DateTime d2 = new DateTime(); if (!DateTime.TryParseExact(TextBox1.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1)) { d1 = DateTime.Now.AddYears(-100); } if (!DateTime.TryParseExact(TextBox2.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d2)) { d2 = DateTime.Now.AddYears(10); } DataTable dt = ql.Search(Convert.ToInt32(DropDownList1.SelectedItem.Value), Convert.ToInt32(DropDownList2.SelectedItem.Value), d1, d2); Repeater1.DataSource = dt; Repeater1.DataBind(); if (dt.Rows.Count == 0) { Table1.Visible = false; Label1.Visible = true; } else { Table1.Visible = true; Label1.Visible = false; } } else { Response.Redirect("Access.aspx"); } }
protected void btnUpload_OnClick(object sender, EventArgs e) { string quoids = Session["quoids"].ToString(); string[] arr = quoids.Split(','); QuotationLogic ql = new QuotationLogic(); Quotation q; string path; string ticks = DateTime.Now.Ticks.ToString(); if (FileUpload1.HasFile) { FileUpload1.SaveAs(Server.MapPath("Images/" + ticks + FileUpload1.FileName)); path = "Images/" + ticks + FileUpload1.FileName; for (int i = 0; i < arr.Length; i++) { q = ql.SelectByID(Convert.ToInt32(arr[i])); q.QuotationPath = path; ql.Update(q); //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage" + arr[i], "alert(" + arr[i] + ")", true); } } // Response.Redirect("QuotationList.aspx"); }
protected void Button1_Click(object sender, EventArgs e) { if (Convert.ToInt32(Request.QueryString["ID"]) > 0) { QuotationLogic ql = new QuotationLogic(); Quotation objQuotation = ql.SelectByID(Convert.ToInt32(Request.QueryString["ID"])); //objQuotation.ProductID = new ProductLogic().SelectByProductName(DropDownList1.Text).ProductID; objQuotation.ProductID = Convert.ToInt32(DropDownList1.SelectedItem.Value); objQuotation.MOQ = Convert.ToInt32(TextBox1.Text); objQuotation.Rate = Convert.ToInt32(TextBox2.Text); // objQuotation.CreateDate = Convert.ToDateTime(TextBox3.Text); DateTime d1 = new DateTime(); if (!DateTime.TryParseExact(TextBox3.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1)) { objQuotation.CreateDate = DateTime.Now; } if (d1.ToShortDateString().Equals(DateTime.Today.ToShortDateString())) { objQuotation.CreateDate = DateTime.Now; } else { objQuotation.CreateDate = d1; } objQuotation.Status = TextBox4.Text; objQuotation.Remarks = TextBox5.Text; objQuotation.TermsConditions = TextBox6.Text; objQuotation.EmployeeID = Convert.ToInt32(Session["EmployeeID"]); objQuotation.QuotationPath = ""; ql.Update(objQuotation); Response.Redirect("QuotationList.aspx"); } else { QuotationLogic ql = new QuotationLogic(); Quotation objQuotation = new Quotation(); //objQuotation.ProductID = new ProductLogic().SelectByProductName(DropDownList1.Text).ProductID; objQuotation.ProductID = Convert.ToInt32(DropDownList1.SelectedItem.Value); objQuotation.MOQ = Convert.ToInt32(TextBox1.Text); objQuotation.Rate = Convert.ToInt32(TextBox2.Text); // objQuotation.CreateDate = Convert.ToDateTime(TextBox3.Text); DateTime d1 = new DateTime(); if (!DateTime.TryParseExact(TextBox3.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1)) { objQuotation.CreateDate = DateTime.Today; } if (d1.ToShortDateString().Equals(DateTime.Today.ToShortDateString())) { objQuotation.CreateDate = DateTime.Now; } else { objQuotation.CreateDate = d1; } objQuotation.Status = TextBox4.Text; objQuotation.Remarks = TextBox5.Text; objQuotation.TermsConditions = TextBox6.Text; objQuotation.EmployeeID = Convert.ToInt32(Session["EmployeeID"]); objQuotation.QuotationPath = ""; ql.Insert(objQuotation); Response.Redirect("QuotationList.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["type"] == "login") { // login request string un = Request.QueryString["un"].ToString(); string pw = Request.QueryString["pw"].ToString(); Employee e1 = new EmployeeLogic().selectUP(un, pw); Response.Write(e1.EmployeeID+ ";"+e1.Username+";"+e1.Password+"---"); return; } else if (Request.QueryString["type"] == "notification") { // no other data is needed QuotationLogic ql = new QuotationLogic(); DataTable dt = ql.SelectNotification(); String resp = ""; foreach (DataRow dr in dt.Rows) { resp = resp + dr["ID"].ToString() + ";"; resp = resp + dr["Data"].ToString() + ";"; resp = resp + dr["Type"].ToString() + ";"; resp = resp + Convert.ToDateTime(dr["Date"]).ToString("dd-MM-yyyy HH:mm:ss") + "---"; } Response.Write(resp); } else if (Request.QueryString["type"] == "employee") { // no other data is needed EmployeeLogic el = new EmployeeLogic(); DataTable dt = el.SelectForAndroid(); String resp = ""; foreach (DataRow dr in dt.Rows) { resp = resp + dr["EmployeeID"].ToString() + ";"; resp = resp + dr["Name"].ToString() + ";"; resp = resp + dr["Phone"].ToString() + "---"; } Response.Write(resp); } else if (Request.QueryString["type"] == "employeeInfo") { // no other data is needed EmployeeLogic el = new EmployeeLogic(); Employee e1 = el.SelectByID(Convert.ToInt32 (Request.QueryString["ID"])); String resp = ""; resp = resp + e1.EmployeeID + ";"; resp = resp + e1.Name + ";"; resp = resp + e1.Designation + ";"; resp = resp + e1.Address+ ";"; resp = resp + e1.Email+ ";"; resp = resp + e1.Phone + ";"; resp = resp + Convert.ToDateTime(e1.DOB.ToString("dd-MM-yyyy"))+ ";"; resp = resp + Convert.ToDateTime(e1.DOJ.ToString("dd-MM-yyyy"))+ ";"; resp = resp + e1.Photo + "---"; Response.Write(resp); } //else if (Request.QueryString["type"] == "Teamlist") //{ // // no other data is needed // TeamLogic tl = new TeamLogic(); // DataTable dt = tl.SelectAll(); // String resp = ""; // foreach (DataRow dr in dt.Rows) // { // resp = resp + dr["TeamID"].ToString() + "-"; // resp = resp + dr["Name"].ToString() + "-"; // resp = resp + dr["CreateDate"].ToString() + "-"; // resp = resp + dr["TeamLeadID"].ToString() + "-"; // resp = resp + dr["ProjectID"].ToString() + "#"; // } // Response.Write(resp); //} //else if (Request.QueryString["type"] == "Versionlist") //{ // // no other data is needed // ProjectVersionLogic PVL = new ProjectVersionLogic(); // DataTable dt = PVL.SelectAll(); // String resp = ""; // foreach (DataRow dr in dt.Rows) // { // resp = resp + dr["ProjectVersionID"].ToString() + "-"; // resp = resp + dr["Name"].ToString() + "-"; // // resp = resp + dr["ProjectID"].ToString() + "-"; // resp = resp + dr["ScheduledStartDate"].ToString() + "-"; // // resp = resp + dr["ActualStartDate"].ToString() + "-"; // resp = resp + dr["ScheduledEndDate"].ToString() + "#"; // } // Response.Write(resp); //} ////public string MD5Hash(string Password) //{ // MD5 md5 = new MD5CryptoServiceProvider(); // //compute hash from the bytes of text // md5.ComputeHash(ASCIIEncoding.ASCII.GetBytes(Password)); // //get hash result after compute it // byte[] result = md5.Hash; // StringBuilder strBuilder = new StringBuilder(); // for (int i = 0; i < result.Length; i++) // { // //change it into 2 hexadecimal digits // //for each byte // strBuilder.Append(result[i].ToString("x2")); // } // return strBuilder.ToString(); //} }
protected void DropDownList1_OnSelectedIndexChanged(object sender, EventArgs e) { QuotationLogic ql = new QuotationLogic(); TextBox1.Text = ql.SelectByProductID(Convert.ToInt32(DropDownList1.SelectedItem.Value)).QuotationID.ToString(); }
protected void Page_Load(object sender, EventArgs e) { EmployeeLogic el = new EmployeeLogic(); Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"])); if (e2.Designation.Equals("COMERCIAL MANAGER") || e2.Designation.Equals("COMERCIAL EMPLOYEE") || e2.Designation.Equals("DESIGNER") || e2.Designation.Equals("PRODUCTION MANAGER") || e2.Designation.Equals("PRODUCTION EMPLOYEE")) { if (!IsPostBack) { ProductLogic pl = new ProductLogic(); DropDownList1.DataSource = pl.SelectAll(); DropDownList1.DataTextField = "Name"; DropDownList1.DataValueField = "ProductID"; DropDownList1.DataBind(); if (Convert.ToInt32(Request.QueryString["id"]) > 0) { OrderLogic ol = new OrderLogic(); Order o1 = ol.SelectByID(Convert.ToInt32(Request.QueryString["id"])); Product p1 = pl.SelectByProductID(o1.ProductID); DropDownList1.SelectedItem.Text = p1.Name; QuotationLogic ql = new QuotationLogic(); TextBox1.Text = ql.SelectByProductID(Convert.ToInt32(DropDownList1.SelectedValue)).QuotationID.ToString(); TextBox2.Text = o1.Quantity.ToString(); TextBox3.Text = o1.Rate.ToString(); TextBox4.Text = o1.PODate.ToString("dd/MM/yyyy"); TextBox5.Text = o1.PONumber.ToString(); TextBox6.Text = o1.CreateDate.ToString("dd/MM/yyyy"); DropDownList2.SelectedItem.Text = o1.Status; TextBox8.Text = o1.StatusRemarks; TextArea2.Text = o1.DeliveryAddress; TextBox9.Text = o1.DeliveryDate.ToString("dd/MM/yyyy"); String po = o1.AttachPO; string ticks = DateTime.Now.Ticks.ToString(); if (FileUpload1.HasFile) { FileUpload1.SaveAs(Server.MapPath("Images/" + ticks + FileUpload1.FileName)); FileUpload1.Visible = false; lnkImage1.Text = po.Substring(25); lnkImage1.NavigateUrl = po; } else { lnkImage1.Visible = false; LinkButton1.Visible = false; } } else { lnkImage1.Visible = false; LinkButton1.Visible = false; QuotationLogic ql = new QuotationLogic(); TextBox1.Text = ql.SelectByProductID(Convert.ToInt32(DropDownList1.SelectedItem.Value)).QuotationID.ToString(); TextBox6.Text = DateTime.Now.ToString("dd/MM/yyyy"); } } Label2.Visible = false; } else { Response.Redirect("Access.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["type"] == "login") { // login request string un = Request.QueryString["un"].ToString(); string pw = Request.QueryString["pw"].ToString(); Employee e1 = new EmployeeLogic().selectUP(un, pw); Response.Write(e1.EmployeeID + ";" + e1.Username + ";" + e1.Password + "---"); return; } else if (Request.QueryString["type"] == "notification") { // no other data is needed QuotationLogic ql = new QuotationLogic(); DataTable dt = ql.SelectNotification(); String resp = ""; foreach (DataRow dr in dt.Rows) { resp = resp + dr["ID"].ToString() + ";"; resp = resp + dr["Data"].ToString() + ";"; resp = resp + dr["Type"].ToString() + ";"; resp = resp + Convert.ToDateTime(dr["Date"]).ToString("dd-MM-yyyy HH:mm:ss") + "---"; } Response.Write(resp); } else if (Request.QueryString["type"] == "employee") { // no other data is needed EmployeeLogic el = new EmployeeLogic(); DataTable dt = el.SelectForAndroid(); String resp = ""; foreach (DataRow dr in dt.Rows) { resp = resp + dr["EmployeeID"].ToString() + ";"; resp = resp + dr["Name"].ToString() + ";"; resp = resp + dr["Phone"].ToString() + "---"; } Response.Write(resp); } else if (Request.QueryString["type"] == "employeeInfo") { // no other data is needed EmployeeLogic el = new EmployeeLogic(); Employee e1 = el.SelectByID(Convert.ToInt32(Request.QueryString["ID"])); String resp = ""; resp = resp + e1.EmployeeID + ";"; resp = resp + e1.Name + ";"; resp = resp + e1.Designation + ";"; resp = resp + e1.Address + ";"; resp = resp + e1.Email + ";"; resp = resp + e1.Phone + ";"; resp = resp + Convert.ToDateTime(e1.DOB.ToString("dd-MM-yyyy")) + ";"; resp = resp + Convert.ToDateTime(e1.DOJ.ToString("dd-MM-yyyy")) + ";"; resp = resp + e1.Photo + "---"; Response.Write(resp); } //else if (Request.QueryString["type"] == "Teamlist") //{ // // no other data is needed // TeamLogic tl = new TeamLogic(); // DataTable dt = tl.SelectAll(); // String resp = ""; // foreach (DataRow dr in dt.Rows) // { // resp = resp + dr["TeamID"].ToString() + "-"; // resp = resp + dr["Name"].ToString() + "-"; // resp = resp + dr["CreateDate"].ToString() + "-"; // resp = resp + dr["TeamLeadID"].ToString() + "-"; // resp = resp + dr["ProjectID"].ToString() + "#"; // } // Response.Write(resp); //} //else if (Request.QueryString["type"] == "Versionlist") //{ // // no other data is needed // ProjectVersionLogic PVL = new ProjectVersionLogic(); // DataTable dt = PVL.SelectAll(); // String resp = ""; // foreach (DataRow dr in dt.Rows) // { // resp = resp + dr["ProjectVersionID"].ToString() + "-"; // resp = resp + dr["Name"].ToString() + "-"; // // resp = resp + dr["ProjectID"].ToString() + "-"; // resp = resp + dr["ScheduledStartDate"].ToString() + "-"; // // resp = resp + dr["ActualStartDate"].ToString() + "-"; // resp = resp + dr["ScheduledEndDate"].ToString() + "#"; // } // Response.Write(resp); //} ////public string MD5Hash(string Password) //{ // MD5 md5 = new MD5CryptoServiceProvider(); // //compute hash from the bytes of text // md5.ComputeHash(ASCIIEncoding.ASCII.GetBytes(Password)); // //get hash result after compute it // byte[] result = md5.Hash; // StringBuilder strBuilder = new StringBuilder(); // for (int i = 0; i < result.Length; i++) // { // //change it into 2 hexadecimal digits // //for each byte // strBuilder.Append(result[i].ToString("x2")); // } // return strBuilder.ToString(); //} }
protected void Page_Load(object sender, EventArgs e) { QuotationLogic QL = new QuotationLogic(); Repeater1.DataSource = QL.SelectNotification(); Repeater1.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { if (Convert.ToInt32(Request.QueryString["ID"]) > 0) { QuotationLogic ql = new QuotationLogic(); Quotation objQuotation = ql.SelectByID(Convert.ToInt32(Request.QueryString["ID"])); //objQuotation.ProductID = new ProductLogic().SelectByProductName(DropDownList1.Text).ProductID; objQuotation.ProductID =Convert.ToInt32(DropDownList1.SelectedItem.Value); objQuotation.MOQ = Convert.ToInt32(TextBox1.Text); objQuotation.Rate = Convert.ToInt32(TextBox2.Text); // objQuotation.CreateDate = Convert.ToDateTime(TextBox3.Text); DateTime d1 = new DateTime(); if (!DateTime.TryParseExact(TextBox3.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1)) { objQuotation.CreateDate = DateTime.Now; } if (d1.ToShortDateString().Equals(DateTime.Today.ToShortDateString())) { objQuotation.CreateDate = DateTime.Now; } else { objQuotation.CreateDate = d1; } objQuotation.Status = TextBox4.Text; objQuotation.Remarks = TextBox5.Text; objQuotation.TermsConditions = TextBox6.Text; objQuotation.EmployeeID = Convert.ToInt32(Session["EmployeeID"]); objQuotation.QuotationPath = ""; ql.Update(objQuotation); Response.Redirect("QuotationList.aspx"); } else { QuotationLogic ql = new QuotationLogic(); Quotation objQuotation = new Quotation(); //objQuotation.ProductID = new ProductLogic().SelectByProductName(DropDownList1.Text).ProductID; objQuotation.ProductID = Convert.ToInt32(DropDownList1.SelectedItem.Value); objQuotation.MOQ = Convert.ToInt32(TextBox1.Text); objQuotation.Rate = Convert.ToInt32(TextBox2.Text); // objQuotation.CreateDate = Convert.ToDateTime(TextBox3.Text); DateTime d1 = new DateTime(); if (!DateTime.TryParseExact(TextBox3.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1)) { objQuotation.CreateDate = DateTime.Today; } if (d1.ToShortDateString().Equals(DateTime.Today.ToShortDateString())) { objQuotation.CreateDate = DateTime.Now; } else { objQuotation.CreateDate = d1; } objQuotation.Status = TextBox4.Text; objQuotation.Remarks = TextBox5.Text; objQuotation.TermsConditions = TextBox6.Text; objQuotation.EmployeeID = Convert.ToInt32(Session["EmployeeID"]); objQuotation.QuotationPath = ""; ql.Insert(objQuotation); Response.Redirect("QuotationList.aspx"); } }