protected void Button1_Click(object sender, EventArgs e)
{
int flag = 0;
if (RadioButton1.Checked == true)
{
if (Convert.ToDecimal(txtSchemaValueDiscount.Text) > Convert.ToDecimal(100))
{
flag = 1;
}
}
if (flag == 0)
{
int discountflag = 0;
if (txtMinValQuantity.Text != "" && txtMaxValQuantity.Text != "")
{
decimal MaxValue1 = Convert.ToDecimal(isdecimalornot(txtMaxValQuantity.Text));
decimal MinValue1 = Convert.ToDecimal(isdecimalornot(txtMinValQuantity.Text));
if (MinValue1 > MaxValue1)
{
discountflag = 1;
}
}
if (discountflag == 0)
{
string str11 = "select Convert(nvarchar,StartDate,101) as StartDate,EndDate from [ReportPeriod] where Compid = '" + compid + "' and Active='1' and Whid='" + ddlWarehouse.SelectedValue + "'";
SqlCommand cmd11 = new SqlCommand(str11, con);
SqlDataAdapter da = new SqlDataAdapter(cmd11);
DataTable dt11 = new DataTable();
da.Fill(dt11);
if (dt11.Rows.Count > 0)
{
if (Convert.ToDateTime(tXtEffectiveStartdate.Text) < Convert.ToDateTime(dt11.Rows[0][0].ToString()))
{
lblstartdate1.Text = dt11.Rows[0][0].ToString();
ModalPopupExtender1222.Show();
}
else
{
int a, b;
DateTime date = Convert.ToDateTime(System.DateTime.Now.ToShortDateString());
if (ddlstatus.SelectedIndex == 1)
{
a = 1;
}
else
{
a = 0;
}
if (RadioButton1.Checked == true)
{
b = 1;
}
else
{
b = 0;
}
decimal c1 = Convert.ToDecimal(isdecimalornot(txtMaxValQuantity.Text));
decimal b1 = Convert.ToDecimal(isdecimalornot(txtMinValQuantity.Text));
if (txtMaxValQuantity.Text == "")
{
c1 = b1 + 1;
}
//if (b1 > c1)
//{
// Label1.Visible = true;
// Label1.Text = "Minimum Quantity must be less than Maximum Quantity";
//}
//else
//{
DateTime dt = Convert.ToDateTime(tXtEffectiveStartdate.Text);
DateTime dt1 = Convert.ToDateTime(txtenddate.Text);
if (dt < Convert.ToDateTime(DateTime.Now.ToShortDateString()))
{
Label1.Visible = true;
Label1.Text = "Start date must be the current date, or greater than the current date";
}
else if (dt1 < dt)
{
Label1.Visible = true;
Label1.Text = "End date must be the current date, or greater than the current date";
}
else
{
try
{
string str111 = "Select * from OrderValueDiscountMaster where SchemeName='" + txtSchemaName.Text + "' and Whid='" + ddlWarehouse.SelectedValue + "'";
SqlCommand cmd111 = new SqlCommand(str111, con);
SqlDataAdapter da1 = new SqlDataAdapter(cmd111);
DataTable dt111 = new DataTable();
da1.Fill(dt111);
if (dt111.Rows.Count == 0)
{
string strinsr = " INSERT INTO OrderValueDiscountMaster " +
"(SchemeName,ValueDiscount,MinValue,MaxValue,StartDate,EndDate,Active,IsPercentage,ApplyOnlineSales,ApplyRetailSales,Whid) " +
" VALUES ('" + txtSchemaName.Text + "','" + isdecimalornot(txtSchemaValueDiscount.Text) + "','" + isdecimalornot(txtMinValQuantity.Text) + "', " +
" '" + txtMaxValQuantity.Text + "','" + tXtEffectiveStartdate.Text + "','" + txtenddate.Text + "', " +
" '" + ddlstatus.SelectedValue + "', '" + b.ToString() + "','" + chkonline.Checked + "','" + chkretail.Checked + "','" + ddlWarehouse.SelectedValue + "') ";
SqlCommand cmd = new SqlCommand(strinsr, con);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmd.ExecuteNonQuery();
con.Close();
Label1.Visible = true;
Label1.Text = "Record inserted successfully";
addinventoryroom.Visible = false;
btnaddroom.Visible = true;
clean();
filldatagrid();
ddlstatus.SelectedIndex = 0;
}
else
{
Label1.Visible = true;
Label1.Text = "Record already exists ";
}
}
catch (Exception ex)
{
Label1.Visible = true;
Label1.Text = "Error";
}
finally { }
}
}
}
}
else
{
Label1.Visible = true;
Label1.Text = "Minimum Order Value must be less than Maximum Order Value";
}
}
else
{
Label1.Visible = true;
Label1.Text = "Order value discount percentage cannot be greater than 100%";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
ModalPopupExtender1222.Show();
//if (ViewState["Id"] != null)
//{
// string st1 = "select * from [WHTimeZone] Where WHTimeZone.WHID ='" + DropDownList1.SelectedValue + "'";
// //and ID != '" + ViewState["Id"] + "' ";
// SqlCommand cmd = new SqlCommand(st1, con);
// SqlDataAdapter adp = new SqlDataAdapter(cmd);
// DataTable dt = new DataTable();
// adp.Fill(dt);
// if (dt.Rows.Count > 0)
// {
// string st2 = "select * from Batchmaster Where batchmaster.BatchTimeZone ='" + dt.Rows[0]["ID"].ToString() + "'";
// SqlCommand cmd2 = new SqlCommand(st2, con);
// SqlDataAdapter adp2 = new SqlDataAdapter(cmd2);
// DataTable dt2 = new DataTable();
// adp2.Fill(dt2);
// if (dt2.Rows.Count > 0)
// {
// lblmsg.Text = "Sorry,you can't set another Time Zone";
// return;
// }
// else
// {
// string str1 = "Update WHTimeZone SET WHID='" + DropDownList1.SelectedValue + "', TimeZone='" + DropDownList2.SelectedValue + "' WHERE ID=" + ViewState["Id"] + "";
// SqlCommand cmd1 = new SqlCommand(str1, con);
// if (con.State.ToString() != "Open")
// {
// con.Open();
// }
// cmd1.ExecuteNonQuery();
// con.Close();
// //SqlDataAdapter adp1 = new SqlDataAdapter(cmd1);
// //DataTable dt1 = new DataTable();
// //adp1.Fill(dt1);
// fillgrid();
// cleartext();
// lblmsg.Text = "Record updated successfully";
// //ImageButton2.Visible = true;
// //Button1.Visible = false;
// pnladd.Visible = false;
// lbladd.Text = "";
// }
// }
//}
//else
//{
// string str1 = "Update WHTimeZone SET WHID='" + DropDownList1.SelectedValue + "', TimeZone='" + DropDownList2.SelectedValue + "' WHERE ID=" + Convert.ToInt16(Session["ID1"]) + "";
// SqlCommand cmd1 = new SqlCommand(str1, con);
// if (con.State.ToString() != "Open")
// {
// con.Open();
// }
// cmd1.ExecuteNonQuery();
// con.Close();
// //SqlDataAdapter adp1 = new SqlDataAdapter(cmd1);
// //DataTable dt1 = new DataTable();
// //adp1.Fill(dt1);
// fillgrid();
// cleartext();
// lblmsg.Text = "Record updated successfully";
// //ImageButton2.Visible = true;
// //Button1.Visible = false;
// pnladd.Visible = false;
// lbladd.Text = "";
//}
//// Label masterkey = (Label) GridView1.FindControl("lbbname");
}
