protected void btnOrder_Click(object sender, EventArgs e) { if (ddlSelect.SelectedValue == "OrderNo") { query = "select IMID,OrderNo,Type,RequiredQt,OrderType,Amount,Refund as RefundedAmount from IMOrder where OrderNo='" + txtOrder.Text + "' and Session='" + lblHiddenSeason.Text + "' ORDER BY OrderNo DESC"; } else if (ddlSelect.SelectedValue == "IMID") { query = "select IMID,OrderNo,Type,RequiredQt,OrderType,Amount,Refund as RefundedAmount from IMOrder where IMID='" + txtIMID.Text + "' and Session='" + lblHiddenSeason.Text + "' ORDER BY OrderNo DESC"; } else if (ddlSelect.SelectedValue == "Type") { query = "select IMID,OrderNo,Type,RequiredQt,OrderType,Amount,Refund as RefundedAmount from IMOrder where Type='" + ddlType.SelectedValue + "' and Session='" + lblHiddenSeason.Text + "' ORDER BY OrderNo DESC"; } else if (ddlSelect.SelectedValue == "Status") { query = "select IMID,OrderNo,Type,RequiredQt,OrderType,Amount,Refund as RefundedAmount from IMOrder where Status='" + ddlStatus.SelectedValue + "' and Session='" + lblHiddenSeason.Text + "' ORDER BY OrderNo DESC"; } else if (ddlSelect.SelectedValue == "Consignment") { query = "select IMID,OrderNo,Type,RequiredQt,OrderType,Amount,Refund as RefundedAmount from IMOrder where ConsignmentNo='" + txtOrder.Text + "' and Session='" + lblHiddenSeason.Text + "' ORDER BY OrderNo DESC"; } SqlDataAdapter ad3 = new SqlDataAdapter(query, con); DataTable dt3 = new DataTable(); ad3.Fill(dt3); GridView1.DataSource = dt3; GridView1.DataBind(); GridView1.Focus(); }
protected void btnOrder_Click(object sender, EventArgs e) { if (ddlSelect.SelectedValue == "OrderNo") { query = "select OrderNo,OrderType,RequiredQt,SupplyQt,Amount from Purches where OrderNo='" + txtOrder.Text + "' and Session='" + lblHiddenSeason.Text + "'"; } else if (ddlSelect.SelectedValue == "Sup") { query = "select OrderNo,OrderType,RequiredQt,SupplyQt,Amount from Purches where Supplier='" + ddlSupplier.SelectedValue + "' and Session='" + lblHiddenSeason.Text + "'"; } else if (ddlSelect.SelectedValue == "Type") { query = "select OrderNo,OrderType,RequiredQt,SupplyQt,Amount from Purches where OrderType='" + ddlType.SelectedValue + "' and Session='" + lblHiddenSeason.Text + "'"; } else if (ddlSelect.SelectedValue == "Status") { query = "select OrderNo,OrderType,RequiredQt,SupplyQt,Amount from Purches where Status='" + ddlStatus.SelectedValue + "'and Session='" + lblHiddenSeason.Text + "'"; } SqlDataAdapter ad3 = new SqlDataAdapter(query, con); DataTable dt3 = new DataTable(); ad3.Fill(dt3); GridView1.DataSource = dt3; GridView1.DataBind(); GridView1.Focus(); }
protected void ontext2(object sender, EventArgs e) { for (int i = 0; i < GridView1.Rows.Count; i++) { System.Web.UI.WebControls.CompareValidator cv = (System.Web.UI.WebControls.CompareValidator)GridView1.Rows[i].FindControl("CompareValidator8"); cv.ValueToCompare = TextBox6.Text; } GridView1.Focus(); }
protected void btnSelectAll_Onclick(object sender, EventArgs e) { int i = 0; while (i < GridView1.Rows.Count) { CheckBox rbApp = (CheckBox)GridView1.Rows[i].FindControl("chkapp"); rbApp.Checked = true; i++; } GridView1.Focus(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!String.IsNullOrWhiteSpace(Request.QueryString["rowIndex"])) { int rowIndex = Convert.ToInt32(Request.QueryString["rowIndex"]); GridView1.Focus(); GridView1.Rows[rowIndex].Cells[0].Focus(); GridView1.Rows[rowIndex].BackColor = System.Drawing.Color.FromArgb(159, 194, 153); } } }
protected void btnOK_OnClcick(object sender, EventArgs e) { try { GridView1.DataSource = fillgrid(); GridView1.DataBind(); } catch (SqlException ex) { lblExceptionOK.Text = ex.ToString(); } finally { GridView1.Focus(); } }
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridView1.PageIndex = e.NewPageIndex; ReLoad(); GridView1.Focus(); }
protected void btnAnnulerSel_Click(object sender, EventArgs e) { GridView1.SelectedIndex = -1; GridView1.Focus(); pnlDelete.Visible = false; }
protected void btnSave_Click(object sender, EventArgs e) { lblException.Visible = false; con.Open(); dtinfo.ShortDatePattern = "dd/MM/yyyy"; dtinfo.DateSeparator = "/"; pnlList.Visible = true; int i = 0; cmd = new SqlCommand("select * from Purches where OrderNo='" + lblOrderNo.Text + "' and OrderType='Books'", con); SqlDataReader read; read = cmd.ExecuteReader(); while (read.Read()) { req = Convert.ToInt32(read["RequiredQt"].ToString()); if (read["SupplyQt"].ToString() == "") { totalQt = 0; } else { totalQt = Convert.ToInt32(read["SupplyQt"].ToString()); } } read.Close(); read.Dispose(); lblException.Text = "Re-Enter Quantity for"; while (i < grdShow.Rows.Count) { TextBox txtQuan = (TextBox)grdShow.Rows[i].FindControl("txtQuantity"); Label lblQuan = (Label)grdShow.Rows[i].FindControl("lblQuantity"); if (txtQuan.Text == "") { txtQuan.Text = "0"; } if (txtQuan.Text != "") { if (Convert.ToInt32(grdShow.Rows[i].Cells[3].Text) == Convert.ToInt32(grdShow.Rows[i].Cells[4].Text)) { } else if (Convert.ToInt32(grdShow.Rows[i].Cells[3].Text) >= Convert.ToInt32(txtQuan.Text) + Convert.ToInt32(grdShow.Rows[i].Cells[4].Text)) { cmd = new SqlCommand("select * from SubjectMaster where CourseID='" + grdShow.Rows[i].Cells[6].Text + "' and SubjectCode='" + grdShow.Rows[i].Cells[1].Text + "'", con); SqlDataReader reader; reader = cmd.ExecuteReader(); while (reader.Read()) { if (reader["Stoke"].ToString() == "") { stoke = 0; } else { stoke = Convert.ToInt32(reader["Stoke"].ToString()); } } reader.Close(); reader.Dispose(); sup = Convert.ToInt32(grdShow.Rows[i].Cells[4].Text.ToString()); int totalSupply = Convert.ToInt32(txtQuan.Text) + sup; cmd = new SqlCommand("update PurchesList set SupplyQt='" + totalSupply.ToString() + "' where OrderNo='" + lblOrderNo.Text + "' and SubjectCode='" + grdShow.Rows[i].Cells[1].Text + "'", con); cmd.ExecuteNonQuery(); stoke = stoke + totalSupply; cmd = new SqlCommand("update SubjectMaster set Stoke='" + stoke.ToString() + "' where CourseID='" + grdShow.Rows[i].Cells[6].Text + "' and SubjectCode='" + grdShow.Rows[i].Cells[1].Text + "'", con); cmd.ExecuteNonQuery(); totalQt += Convert.ToInt32(txtQuan.Text); } else { lblException.Visible = true; lblException.Text += " " + grdShow.Rows[i].Cells[1].Text + ", "; } } i++; } lblSupply.Text = totalQt.ToString(); if (req == Convert.ToInt32(lblSupply.Text)) { status = "Delivered"; } else { status = "Ordered"; } cmd = new SqlCommand("update Purches set SupplyQt='" + lblSupply.Text + "',DeliverDate='" + Convert.ToDateTime(DateTime.Now.ToString("dd/MM/yyyy"), dtinfo) + "',Status='" + status + "' where OrderNo='" + lblOrderNo.Text + "' and OrderType='Books'", con); cmd.ExecuteNonQuery(); con.Close(); con.Dispose(); GridView1.DataBind(); grdShow.DataBind(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "success", "alert('Successful Save.!')", true); GridView1.Focus(); }
protected void bt_can_elim_Click(object sender, EventArgs e) { GridView1.Focus(); }
protected void btnShow_Click(object sender, EventArgs e) { grid(); GridView1.Focus(); }
protected void Button2_Click(object sender, EventArgs e) { // Add Question Button maxValue = Convert.ToInt32(TextBox1.Text); // Response.Write("count the value = " + Convert.ToString(mark)); /* CHECKING WHETHER THE QUESTION SELECTED ALREADY EXIST OR NOT ... */ int i = GridView1.Rows.Count; if (i == 0) { for (int k = 0; k < CheckBoxList2.Items.Count; k++) { if (CheckBoxList2.Items[k].Selected == true) { dt = (DataTable)ViewState["Records"]; dt.Rows.Add(CheckBoxList3.Items[k], CheckBoxList2.Items[k], DropDownList3.SelectedItem); GridView1.DataSource = dt; GridView1.DataBind(); ViewState["count"] = Convert.ToInt32(ViewState["count"]) + mark; } } return; } else { /* THIS LOOP WILL EXECUTE ALL THE ITEMS IN CHECKBOXLIST */ for (int l = 0; l < CheckBoxList2.Items.Count; l++) { //IF THE ITEM IS CHECKED THEN IF CONDITION WILL BE EXECUTED if (CheckBoxList2.Items[l].Selected == true) { string ckcval = CheckBoxList2.Items[l].ToString(); int count = GridView1.Rows.Count; int j = 0; int same_v = 0; // THIS LOOP WILL CHECK THAT THE CHECKED ITEM IS THERE IN GRIDVIEW OR NOT while (j < count) { string str = GridView1.Rows[j].Cells[1].Text; // IF VALUE EXIST THAN THE VARAILE WILL BE INCREAMENTED AND WHILE LOOP WILL BE BREAKED if (str == ckcval) { same_v++; break; } j++; } // IF VALUE DOESNOT EXIST THAN IT WILL BE ADDED IN THE GRIDVIEW if (same_v == 0) { dt = (DataTable)ViewState["Records"]; dt.Rows.Add(CheckBoxList3.Items[l], CheckBoxList2.Items[l], DropDownList3.SelectedItem); GridView1.DataSource = dt; GridView1.DataBind(); ViewState["count"] = Convert.ToInt32(ViewState["count"]) + mark; } } } } GridView1.Focus(); // Response.Write("total mark =" + ViewState["count"]); }
protected void GridView1_RowDeleted(object sender, GridViewDeletedEventArgs e) { GridView1.Focus(); }
protected void bt_can_elim_Click(object sender, EventArgs e) { confirmar_elim.Visible = false; GridView1.Focus(); }
protected void btnSupply_Click(object sender, EventArgs e) { lblException.Text = ""; con.Open(); dtinfo.ShortDatePattern = "dd/MM/yyyy"; dtinfo.DateSeparator = "/"; if (btnSupply.Enabled == true) { int i = 0; cmd = new SqlCommand("select * from IMOrder where OrderNo='" + lblOrderNo.Text + "'", con); SqlDataReader read; read = cmd.ExecuteReader(); while (read.Read()) { ordertype = read["OrderType"].ToString(); req = Convert.ToInt32(read["RequiredQt"].ToString()); if (read["SupplyQt"].ToString() == "") { totalQt = 0; } else { totalQt = Convert.ToInt32(read["SupplyQt"].ToString()); } } read.Close(); read.Dispose(); while (i < grdShow.Rows.Count) { TextBox txtQuan = (TextBox)grdShow.Rows[i].FindControl("txtQuantity"); Label lblQuan = (Label)grdShow.Rows[i].FindControl("lblQuantity"); if (txtQuan.Text == "") { txtQuan.Text = "0"; } if (txtQuan.Text != "") { if (Convert.ToInt32(grdShow.Rows[i].Cells[4].Text) == Convert.ToInt32(grdShow.Rows[i].Cells[5].Text)) { } else if (Convert.ToInt32(grdShow.Rows[i].Cells[4].Text) >= Convert.ToInt32(txtQuan.Text) + Convert.ToInt32(grdShow.Rows[i].Cells[5].Text)) { cmd = new SqlCommand("select * from SubjectMaster where CourseID='" + grdShow.Rows[i].Cells[7].Text + "' and SubjectCode='" + grdShow.Rows[i].Cells[2].Text + "'", con); SqlDataReader reader; reader = cmd.ExecuteReader(); while (reader.Read()) { if (reader["Stoke"].ToString() == "") { stoke = 0; } else { stoke = Convert.ToInt32(reader["Stoke"].ToString()); } } reader.Close(); reader.Dispose(); sup = Convert.ToInt32(grdShow.Rows[i].Cells[5].Text.ToString()); int totalSupply = Convert.ToInt32(txtQuan.Text) + sup; //if (stoke >= Convert.ToInt32(txtQuan.Text)) //{ cmd = new SqlCommand("update IMOrderList set Supply='" + totalSupply + "' where OrderNo='" + lblOrderNo.Text + "' and SubjectCode='" + grdShow.Rows[i].Cells[2].Text + "' and CourseId='" + grdShow.Rows[i].Cells[7].Text + "'", con); cmd.ExecuteNonQuery(); stoke = stoke - Convert.ToInt32(txtQuan.Text); cmd = new SqlCommand("update SubjectMaster set Stoke='" + stoke + "' where SubjectCode='" + grdShow.Rows[i].Cells[2].Text + "' and CourseId='" + grdShow.Rows[i].Cells[7].Text + "'", con); cmd.ExecuteNonQuery(); totalQt += Convert.ToInt32(txtQuan.Text); //} //else //{ // except += grdShow.Rows[i].Cells[2].Text + ","; //} } else { lblException.Text = "Supply Quantity is greater than Required!!"; } } if (ordertype == "NonAuto") { cmd = new SqlCommand("select Stock from IMStock where IMID='" + lblIMID.Text + "' and SubCode='" + grdShow.Rows[i].Cells[2].Text + "'", con); int stock = Convert.ToInt32(cmd.ExecuteScalar()); cmd = new SqlCommand("update IMStock set Stock='" + (stock + Convert.ToInt32(txtQuan.Text)) + "' where IMID='" + lblIMID.Text + "' and SubCode='" + grdShow.Rows[i].Cells[2].Text + "'", con); cmd.ExecuteNonQuery(); } else if (ordertype == "Auto") { cmd = new SqlCommand("select Stock from IMStock where IMID='" + lblIMID.Text + "' and SubCode='" + grdShow.Rows[i].Cells[2].Text + "'", con); int stock = Convert.ToInt32(cmd.ExecuteScalar()); cmd = new SqlCommand("update IMStock set Stock='" + (stock + Convert.ToInt32(txtQuan.Text)) + "' where IMID='" + lblIMID.Text + "' and SubCode='" + grdShow.Rows[i].Cells[2].Text + "'", con); cmd.ExecuteNonQuery(); } i++; } if (except == null) { if (req == totalQt) { if (ordertype == "NonAuto") { cmd = new SqlCommand("update IMOrder set SupplyQt='" + totalQt + "',Status='Supplied',DeliverDate='" + DateTime.Now + "' where OrderNo='" + lblOrderNo.Text + "' and IMID='" + lblIMID.Text + "' ", con); } else if (ordertype == "Auto") { cmd = new SqlCommand("update IMOrder set SupplyQt='" + totalQt + "',Status='Generated',DeliverDate='" + DateTime.Now + "' where OrderNo='" + lblOrderNo.Text + "' and IMID='" + lblIMID.Text + "' ", con); } } else { cmd = new SqlCommand("update IMOrder set SupplyQt='" + totalQt + "',Status='Generated',DeliverDate='" + DateTime.Now + "' where OrderNo='" + lblOrderNo.Text + "' and IMID='" + lblIMID.Text + "' ", con); } cmd.ExecuteNonQuery(); } else { lblException.Text = ""; // "Stock Not Available For:" + except; } GridView1.DataBind(); grdShow.DataBind(); GridView1.Focus(); con.Close(); con.Dispose(); } flag = true; btnSupply.Enabled = false; }
protected void Page_Load(object sender, EventArgs e) { try { if (IsPostBack == false) { panelAdmin.Visible = false; panelAdminDelete.Visible = false; paneldelete.Visible = false; panelCreate.Visible = false; panelupdate.Visible = false; if (Request.QueryString["lnk"] == "delete") { paneldelete.Visible = true; } else if (Request.QueryString["lnk"] == "update") { panelAdminDelete.Visible = false; panelupdate.Visible = true; } else { panelCreate.Visible = true; } SqlDataReader reader; con.Close(); con.Open(); SqlCommand cmd = new SqlCommand("select * from Login where LogName='" + Convert.ToString(MyLogin.login[1]) + "' and Password='******'", con); reader = cmd.ExecuteReader(); if (reader.Read()) { int lvl = Convert.ToInt32(reader[20].ToString()); if (lvl == 0) { } else if (lvl == 1) { reader.Close(); con.Close(); con.Dispose(); Response.Redirect("../SuperAdmin.aspx?" + Request.Cookies["redic"].Value.ToString()); } else if (lvl == 2) { reader.Close(); con.Close(); con.Dispose(); Response.Redirect("Admin/SuperAdminManage.aspx"); } } reader.Close(); con.Close(); con.Dispose(); EnableUpdate(); if (Request.QueryString["lnk"] == "delete") { GridView1.Focus(); } else if (Request.QueryString["lnk"] == "update") { txtPasswordUp.Focus(); } else { txtUserName.Focus(); } } } catch (NullReferenceException ex) { Response.Redirect("../Login.aspx"); } }
protected void btnView_Click(object sender, EventArgs e) { con.Open(); GridView1.Visible = true; string qry = ""; if (CheckBox1.Checked == true) { if (DropDownList1.SelectedValue.ToString() == "SID") { qry = "select SID,Name,FName,MName,Mobile,Email,DOB,IMID,IMName,EnrollDate from Student where SID='" + txtSearch.Text + "' and Session='" + lblSeasonHidden.Text + "' "; } if (DropDownList1.SelectedValue.ToString() == "IMID") { qry = "select SID,Name,FName,MName,Mobile,Email,DOB,IMID,IMName,EnrollDate from Student where IMID='" + txtSearch.Text + "' and Session='" + lblSeasonHidden.Text + "'"; } if (DropDownList1.SelectedValue.ToString() == "Name") { qry = "select SID,Name,FName,MName,Mobile,Email,DOB,IMID,IMName,EnrollDate from Student where Name like '%" + txtSearch.Text + "%' and Session='" + lblSeasonHidden.Text + "'"; } if (DropDownList1.SelectedValue.ToString() == "SerialNo") { SqlCommand cm = new SqlCommand("select Enrolment from AppRecord where FormType like '%" + txtSearch.Text + "NewAdmission%' and Session='" + lblSeasonHidden.Text + "'", con); string stcm = Convert.ToString(cm.ExecuteScalar()); cm.ExecuteNonQuery(); qry = "select SID,Name,FName,MName,Mobile,Email,DOB,IMID,IMName,EnrollDate from Student where SID='" + stcm + "'"; } if (DropDownList1.SelectedValue.ToString() == "Status") { if (chkIMID.Checked == true) { qry = "select SID,Name,FName,MName,Mobile,Email,DOB,IMID,IMName,EnrollDate from Student where Status='" + DropDownList2.SelectedValue + "' and IMID='" + txtSearch.Text + "' and Session='" + lblSeasonHidden.Text + "' "; } else if (chkIMID.Checked == false) { qry = "select SID,Name,FName,MName,Mobile,Email,DOB,IMID,IMName,EnrollDate from Student where Status='" + DropDownList2.SelectedValue + "' and Session='" + lblSeasonHidden.Text + "' "; } } } else if (CheckBox1.Checked == false) { if (DropDownList1.SelectedValue.ToString() == "SID") { qry = "select SID,Name,FName,MName,Mobile,Email,DOB,IMID,IMName,EnrollDate from Student where SID='" + txtSearch.Text + "' "; } if (DropDownList1.SelectedValue.ToString() == "IMID") { qry = "select SID,Name,FName,MName,Mobile,Email,DOB,IMID,IMName,EnrollDate from Student where IMID='" + txtSearch.Text + "' and Session='" + lblSeasonHidden.Text + "'"; } if (DropDownList1.SelectedValue.ToString() == "Name") { qry = "select SID,Name,FName,MName,Mobile,Email,DOB,IMID,IMName,EnrollDate from Student where Name like '%" + txtSearch.Text + "%' "; } if (DropDownList1.SelectedValue.ToString() == "SerialNo") { SqlCommand cm = new SqlCommand("select Enrolment from AppRecord where FormType like '%" + txtSearch.Text + "NewAdmission%' and Session='" + lblSeasonHidden.Text + "'", con); string stcm = Convert.ToString(cm.ExecuteScalar()); cm.ExecuteNonQuery(); qry = "select SID,Name,FName,MName,Mobile,Email,DOB,IMID,IMName,EnrollDate from Student where SID='" + stcm + "'"; } if (DropDownList1.SelectedValue.ToString() == "Status") { if (chkIMID.Checked == true) { qry = "select SID,Name,FName,MName,Mobile,Email,DOB,IMID,IMName,EnrollDate from Student where Status='" + DropDownList2.SelectedValue + "' and IMID='" + txtSearch.Text + "' "; } else if (chkIMID.Checked == false) { qry = "select SID,Name,FName,MName,Mobile,Email,DOB,IMID,IMName,EnrollDate from Student where Status='" + DropDownList2.SelectedValue + "' "; } } } SqlDataAdapter ad = new SqlDataAdapter(); ad = new SqlDataAdapter(qry, con); DataTable at = new DataTable(); ad.Fill(at); GridView1.DataSource = at; GridView1.DataBind(); con.Close(); GridView1.Focus(); }