예제 #1
0
		/// <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);	
			}
		}
예제 #2
0
		/// <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 );	
			}
		}