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