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 "; } }