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