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