/// <summary> /// this is used to Update the scheme on behalf of the selected scheme in dropdown. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnupdate_Click(object sender, System.EventArgs e) { try { InventoryClass obj = new InventoryClass(); SqlDataReader SqlDtr = null; //by vikas 02.06.09 obj.schtype=DropSchType.SelectedItem.Text.ToString(); //Coment By Vikas 1.1.2012 obj.schtype="Primary(LTR&% Scheme)"; obj.schtype = DropType.SelectedValue.ToString(); string scheme = dropschid.SelectedItem.Text.Trim().ToString(); string[] schid = scheme.Split(new char[] { ':' }, scheme.Length); obj.schid = schid[0]; if (txtschname.Text.Equals("")) { obj.schname = ""; } else { obj.schname = txtschname.Text.ToString(); } if (txtSchDiscount.Text.Equals("")) { obj.discount = ""; } else { obj.discount = txtSchDiscount.Text.ToString(); } obj.discounttype = DropSchDiscount.SelectedItem.Text; obj.dateto = System.Convert.ToDateTime(GenUtil.str2DDMMYYYY(Request.Form["txtDateTo"].ToString())); obj.datefrom = System.Convert.ToDateTime(GenUtil.str2DDMMYYYY(Request.Form["txtDateFrom"].ToString())); if (ListEmpAssigned.Items.Count != 0) { for (int i = 0; i < ListEmpAssigned.Items.Count; ++i) { ListEmpAssigned.SelectedIndex = i; string pname = ListEmpAssigned.SelectedItem.Value; string[] arr1 = pname.Split(new char[] { ':' }, pname.Length); InventoryClass obj1 = new InventoryClass(); SqlDataReader rdr, rdr1 = null; //02.06.09string sname=DropSchType.SelectedItem.Text; string schname = ""; string sql1 = "select Prod_ID from Products where Prod_Name='" + arr1[0] + "' and Pack_Type='" + arr1[1] + "'"; rdr = obj1.GetRecordSet(sql1); if (rdr.Read()) { sql1 = "select * from StktSchDiscount where Prodid='" + rdr["Prod_ID"].ToString() + "' and sch_id='" + schid[0] + "'"; dbobj.SelectQuery(sql1, ref rdr1); if (rdr1.Read()) { } else { /*if(sname.IndexOf("Free")>0) * schname="Free Scheme"; * else if(sname.IndexOf("LTR&%")>0) * schname="LTR&% Scheme"; * else if(sname.IndexOf("LTRSP")>0) * schname="LTRSP Scheme"; * else * schname="LTR Scheme";*/ //Coment By Vikas 1.1.2013 schname="Primary(LTR&% Scheme)"; //if(DropType.SelectedIndex==1) // schname="Primary(LTR&% Scheme)"; //else if(DropType.SelectedIndex==2) schname = DropType.SelectedItem.Value.ToString(); sql1 = "select * from StktSchDiscount where Prodid='" + rdr["Prod_ID"].ToString() + "'and SchType like '%" + schname + "%' and (cast(floor(cast(datefrom as float)) as datetime)>='" + GenUtil.str2MMDDYYYY(GenUtil.trimDate(txtDateFrom.Text)) + "' and cast(floor(cast(dateto as float)) as datetime)<='" + GenUtil.str2MMDDYYYY(GenUtil.trimDate(txtDateTo.Text)) + "' or cast(floor(cast(datefrom as float)) as datetime) between '" + GenUtil.str2MMDDYYYY(GenUtil.trimDate(txtDateFrom.Text)) + "' and '" + GenUtil.str2MMDDYYYY(GenUtil.trimDate(txtDateTo.Text)) + "' or cast(floor(cast(dateto as float)) as datetime) between '" + GenUtil.str2MMDDYYYY(GenUtil.trimDate(txtDateFrom.Text)) + "' and '" + GenUtil.str2MMDDYYYY(GenUtil.trimDate(txtDateTo.Text)) + "')"; dbobj.SelectQuery(sql1, ref SqlDtr); if (SqlDtr.Read()) { MessageBox.Show("'" + pname + "'" + " Allready Exist"); return; } } } rdr.Close(); } } else { MessageBox.Show("Please Select At Least One Product"); return; } SqlConnection SqlCon = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Servosms"]); SqlCon.Open(); SqlCommand cmd; cmd = new SqlCommand("delete from StktschDiscount where sch_id='" + schid[0] + "'", SqlCon); cmd.ExecuteNonQuery(); SqlCon.Close(); cmd.Dispose(); for (int i = 0; i < ListEmpAssigned.Items.Count; ++i) { ListEmpAssigned.SelectedIndex = i; string pname = ListEmpAssigned.SelectedItem.Value; string[] arr1 = pname.Split(new char[] { ':' }, pname.Length); string sql1 = "select Prod_ID from Products where Prod_Name='" + arr1[0] + "' and Pack_Type='" + arr1[1] + "'"; dbobj.SelectQuery(sql1, ref SqlDtr); while (SqlDtr.Read()) { obj.prodid = SqlDtr.GetValue(0).ToString(); obj.InsertStockiestSchemediscount(); } } MessageBox.Show("Stockiest Discount Updated"); Clear(); FillList(); GetNextschemeID(); dropschid.Visible = false; btnupdate.Visible = false; lblschid.Visible = true; btnSubmit.Visible = true; btnSubmit.Enabled = true; btschid.Visible = true; CreateLogFiles.ErrorLog("Form:StockiestDiscountEntry.aspx,Method:btnupdate_Click Stockiest Discount Entry Updated, User " + uid); } catch (Exception ex) { CreateLogFiles.ErrorLog("Form:Schemediscount.aspx,Method:btnupdate_Click EXCEPTION " + ex.Message + " User " + uid); } }
/// <summary> /// this is used to save the scheme . /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, System.EventArgs e) { try { string schname = ""; InventoryClass obj = new InventoryClass(); //string sql; SqlDataReader SqlDtr = null; if (ListEmpAssigned.Items.Count != 0) { for (int i = 0; i < ListEmpAssigned.Items.Count; ++i) { ListEmpAssigned.SelectedIndex = i; string pname = ListEmpAssigned.SelectedItem.Value; string[] arr1 = pname.Split(new char[] { ':' }, pname.Length); InventoryClass obj1 = new InventoryClass(); SqlDataReader rdr; //string sname=DropSchType.SelectedItem.Text; string sql1 = "select Prod_ID from Products where Prod_Name='" + arr1[0] + "' and Pack_Type='" + arr1[1] + "'"; rdr = obj1.GetRecordSet(sql1); if (rdr.Read()) { /*02.06.09if(sname.IndexOf("Free")>0) * schname="Free Scheme"; * else if(sname.IndexOf("LTR&%")>0) * schname="LTR&% Scheme"; * else if(sname.IndexOf("LTRSP")>0) * schname="LTRSP Scheme"; * else * schname="LTR Scheme";*/ // Coment By Vikas 1.1.2013 schname="Primary(LTR&% Scheme)"; if (DropType.SelectedIndex == 1) { schname = "Primary(LTR&% Scheme)"; } else if (DropType.SelectedIndex == 2) { schname = DropType.SelectedItem.Value.ToString(); } sql1 = "select * from StktSchDiscount where Prodid='" + rdr["Prod_ID"].ToString() + "' and schtype like '%" + schname + "%' and (cast(floor(cast(datefrom as float)) as datetime)>='" + GenUtil.str2MMDDYYYY(GenUtil.trimDate(txtDateFrom.Text)) + "' and cast(floor(cast(dateto as float)) as datetime)<='" + GenUtil.str2MMDDYYYY(GenUtil.trimDate(txtDateTo.Text)) + "' or cast(floor(cast(datefrom as float)) as datetime) between '" + GenUtil.str2MMDDYYYY(GenUtil.trimDate(txtDateFrom.Text)) + "' and '" + GenUtil.str2MMDDYYYY(GenUtil.trimDate(txtDateTo.Text)) + "' or cast(floor(cast(dateto as float)) as datetime) between '" + GenUtil.str2MMDDYYYY(GenUtil.trimDate(txtDateFrom.Text)) + "' and '" + GenUtil.str2MMDDYYYY(GenUtil.trimDate(txtDateTo.Text)) + "')"; dbobj.SelectQuery(sql1, ref SqlDtr); if (SqlDtr.Read()) { MessageBox.Show("'" + pname + "'" + " Allready Exist"); return; } } rdr.Close(); } } else { MessageBox.Show(" Please Select At Least One Product "); return; } //obj.schtype=DropSchType.SelectedItem.Text.ToString(); //Coment by Vikas 1/1/2013 obj.schtype="Primary(LTR&% Scheme)"; obj.schtype = schname; obj.schid = lblschid.Text; if (txtschname.Text.Equals("")) { obj.schname = ""; } else { obj.schname = txtschname.Text.ToString(); } // if(DropShiftID.SelectedItem.Text.Equals("Primary(Free Scheme)") || DropShiftID.SelectedItem.Text.Equals("Secondry(Free Scheme)")) // { // string pname1=dropfoc.SelectedItem.Text.ToString(); // // string[] arr2=pname1.Split(new char[]{':'},pname1.Length); // sql="select Prod_ID from Products where Prod_Name='"+arr2[0]+"' and Pack_Type='"+arr2[1]+"'"; // SqlDtr = obj.GetRecordSet (sql); // while(SqlDtr.Read ()) // { // obj.schprodid=SqlDtr.GetValue(0).ToString(); // } // SqlDtr.Close(); // } // else // { // obj.schprodid=""; // } // if(txtevery.Text.Equals("")) // obj.onevery=""; // else // obj.onevery=txtevery.Text.ToString(); // if(txtfree.Text.Equals("")) // obj.freepack=""; // else // obj.freepack=txtfree.Text.ToString(); if (txtSchDiscount.Text.Equals("")) { obj.discount = ""; } else { obj.discount = txtSchDiscount.Text.ToString(); } obj.discounttype = DropSchDiscount.SelectedItem.Text; obj.dateto = System.Convert.ToDateTime(GenUtil.str2DDMMYYYY(Request.Form["txtDateTo"].ToString())); obj.datefrom = System.Convert.ToDateTime(GenUtil.str2DDMMYYYY(Request.Form["txtDateFrom"].ToString())); //obj.Type=DropType.SelectedItem.Text; for (int i = 0; i < ListEmpAssigned.Items.Count; ++i) { ListEmpAssigned.SelectedIndex = i; string pname = ListEmpAssigned.SelectedItem.Value; string[] arr1 = pname.Split(new char[] { ':' }, pname.Length); string sql1 = "select Prod_ID from Products where Prod_Name='" + arr1[0] + "' and Pack_Type='" + arr1[1] + "'"; dbobj.SelectQuery(sql1, ref SqlDtr); while (SqlDtr.Read()) { obj.prodid = SqlDtr.GetValue(0).ToString(); obj.InsertStockiestSchemediscount(); } } SqlDtr.Close(); MessageBox.Show("Stockiest Scheme Saved"); Clear(); FillList(); GetNextschemeID(); CreateLogFiles.ErrorLog("Form:ServoStockiestStockiestDiscountEntry.aspx,Method:btnSubmit_Click Stockiest Discount Entry Saved, User : "******"Form:Schemediscount.aspx,Method:btnSubmit_Click EXCEPTION " + ex.Message); } }