/// <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; //obj.schtype=DropSchType.SelectedItem.Text.ToString(); obj.schtype="Secondry Claim"; 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; //string 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]+"'"; sql1="select * from Prod_Promo_Grade_Entry where Prodid='"+rdr["Prod_ID"].ToString()+"' and PPGE_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";*/ schname="Secondry Claim"; //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(Request.Form["txtDateFrom"].ToString()) +"' and cast(floor(cast(dateto as float)) as datetime)<='"+GenUtil.str2MMDDYYYY(Request.Form["txtDateTo"].ToString()) +"' or cast(floor(cast(datefrom as float)) as datetime) between '"+GenUtil.str2MMDDYYYY(Request.Form["txtDateFrom"].ToString()) +"' and '"+GenUtil.str2MMDDYYYY(Request.Form["txtDateTo"].ToString()) +"' or cast(floor(cast(dateto as float)) as datetime) between '"+GenUtil.str2MMDDYYYY(Request.Form["txtDateFrom"].ToString()) +"' and '"+GenUtil.str2MMDDYYYY(Request.Form["txtDateTo"].ToString()) +"')"; sql1="select * from Prod_Promo_Grade_Entry where Prodid='"+rdr["Prod_ID"].ToString()+"'and SchType like '%"+schname+"%' and (cast(floor(cast(datefrom as float)) as datetime)>='"+GenUtil.str2MMDDYYYY(Request.Form["txtDateFrom"].ToString()) +"' and cast(floor(cast(dateto as float)) as datetime)<='"+GenUtil.str2MMDDYYYY(Request.Form["txtDateTo"].ToString()) +"' or cast(floor(cast(datefrom as float)) as datetime) between '"+GenUtil.str2MMDDYYYY(Request.Form["txtDateFrom"].ToString()) +"' and '"+GenUtil.str2MMDDYYYY(Request.Form["txtDateTo"].ToString()) +"' or cast(floor(cast(dateto as float)) as datetime) between '"+GenUtil.str2MMDDYYYY(Request.Form["txtDateFrom"].ToString()) +"' and '"+GenUtil.str2MMDDYYYY(Request.Form["txtDateTo"].ToString()) +"')"; 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=new SqlCommand("delete from Prod_Promo_Grade_Entry where PPGE_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(); obj.InsertPPGE(); } } 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:Prod_Promo_Dis_Entry.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 { 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 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 ()) { /*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";*/ schname="Secondry Claim"; //coment by vikas 02.06.09 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(Request.Form["txtDateFrom"].ToString()) +"' and cast(floor(cast(dateto as float)) as datetime)<='"+GenUtil.str2MMDDYYYY(Request.Form["txtDateTo"].ToString()) +"' or cast(floor(cast(datefrom as float)) as datetime) between '"+GenUtil.str2MMDDYYYY(Request.Form["txtDateFrom"].ToString()) +"' and '"+GenUtil.str2MMDDYYYY(Request.Form["txtDateTo"].ToString()) +"' or cast(floor(cast(dateto as float)) as datetime) between '"+GenUtil.str2MMDDYYYY(Request.Form["txtDateFrom"].ToString()) +"' and '"+GenUtil.str2MMDDYYYY(Request.Form["txtDateTo"].ToString()) +"')"; sql1="select * from Prod_Promo_Grade_Entry where Prodid='"+rdr["Prod_ID"].ToString()+"' and schtype like '%"+schname+"%' and (cast(floor(cast(datefrom as float)) as datetime)>='"+GenUtil.str2MMDDYYYY(Request.Form["txtDateFrom"].ToString()) +"' and cast(floor(cast(dateto as float)) as datetime)<='"+GenUtil.str2MMDDYYYY(Request.Form["txtDateTo"].ToString()) +"' or cast(floor(cast(datefrom as float)) as datetime) between '"+GenUtil.str2MMDDYYYY(Request.Form["txtDateFrom"].ToString()) +"' and '"+GenUtil.str2MMDDYYYY(Request.Form["txtDateTo"].ToString()) +"' or cast(floor(cast(dateto as float)) as datetime) between '"+GenUtil.str2MMDDYYYY(Request.Form["txtDateFrom"].ToString()) +"' and '"+GenUtil.str2MMDDYYYY(Request.Form["txtDateTo"].ToString()) +"')"; 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(); obj.schtype="Secondry Claim"; obj.schid=lblschid.Text; 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())); 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(); obj.InsertPPGE(); //add by vikas 02.06.09 } } SqlDtr.Close(); MessageBox.Show("Product Promotion Grade Saved"); Clear(); FillList(); GetNextschemeID(); CreateLogFiles.ErrorLog("Form:Prod_Promo_Dis_Entry.aspx,Method:btnSubmit_Click Stockiest Discount Entry Saved, User : "******"Form:Prod_Promo_Dis_Entry.aspx,Method:btnSubmit_Click EXCEPTION "+ex.Message ); } }