/// <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 );
}
}
