protected void ImageButton2_Click(object sender, EventArgs e)
{
ModalPopupExtender12222.Hide();
}
protected void Button1_Click1(object sender, EventArgs e)
{
GridViewRow ft = (GridViewRow)GrdOrdrQtyMaster.FooterRow;
TextBox scemname = (TextBox)(ft.FindControl("txtFooterScmName"));
TextBox std = (TextBox)(ft.FindControl("txtFooterStartDate"));
TextBox edd = (TextBox)(ft.FindControl("txtFooterEndDate"));
CheckBox act = (CheckBox)(ft.FindControl("CheckBoxFootr"));
CheckBox isper21 = (CheckBox)(ft.FindControl("chkFooterPercent"));
TextBox disc21 = (TextBox)(ft.FindControl("txtFooterDescount"));
string str111 = "Select FeatureProdDiscountSchemeName from FeatureProdDiscountMaster where FeatureProdDiscountSchemeName='" + scemname.Text + "' and compid='" + Session["comid"] + "'";
SqlCommand cmdstr111 = new SqlCommand(str111, con);
SqlDataAdapter dastr111 = new SqlDataAdapter(cmdstr111);
DataTable dtstr111 = new DataTable();
dastr111.Fill(dtstr111);
if (dtstr111.Rows.Count == 0)
{
string str = "Select Convert(varchar,FirstYearStartDate,101) from CompanyMaster where Compid='" + compid + "'";
SqlCommand cmd = new SqlCommand(str, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
if (Convert.ToDateTime(std.Text) < Convert.ToDateTime(dt.Rows[0][0].ToString()))
{
lblstartdate.Text = dt.Rows[0][0].ToString();
ModalPopupExtender12222.Show();
}
else
{
DateTime dt2 = Convert.ToDateTime(std.Text);
DateTime dt1 = Convert.ToDateTime(edd.Text);
if (dt2 < Convert.ToDateTime(DateTime.Now.ToShortDateString()))
{
Label1.Visible = true;
Label1.Text = " The start date must be the current date, or greater than the current date.";
}
else if (dt1 < dt2)
{
Label1.Visible = true;
Label1.Text = " Start Date must be less than End Date";
}
else
{
if (con.State.ToString() != "Open")
{
con.Open();
}
string strinsert = "insert into FeatureProdDiscountMaster(FeatureProdDiscountSchemeName, " +
" StartDate ,EndDate,Active,compid ) " +
"Values ('" + scemname.Text + "','" + std.Text + "','" + edd.Text + "','" + act.Checked + "','" + compid + "') ";
SqlCommand cmdinsert = new SqlCommand(strinsert, con);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmdinsert.ExecuteNonQuery();
con.Close();
Label1.Visible = true;
Label1.Text = "Record inserted successfully";
PromotionSchemaFill();
}
}
}
}
else
{
Label1.Visible = true;
Label1.Text = "This name is already used ";
}
}
