protected void Page_Load(object sender, EventArgs e)
{
if (Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"]) == null)
{
Response.Redirect("../Login.aspx");
}
if (!IsPostBack)
{
maikal dev = new maikal();
int se = dev.chksession();
if (se == 0)
{
ddlExamSeason.SelectedValue = "Sum";
}
else
{
ddlExamSeason.SelectedValue = "Win";
}
txtYearSeason.Text = DateTime.Now.Year.ToString();
lblExamSeasonHidden.Text = ddlExamSeason.SelectedValue.ToString() + "" + txtYearSeason.Text.ToString();
lblSessionID.Text = sd.SessionToSessionID(lblExamSeasonHidden.Text).ToString();
txtSID.Focus();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"])) == "")
{
Response.Redirect("../Login.aspx");
}
if (!IsPostBack)
{
btnAdd.Visible = false;
txtYearSeason.Text = DateTime.Now.Year.ToString();
string yr = DateTime.Now.Year.ToString();
maikal dev = new maikal();
int se = dev.chksession();
if (se == 0)
{
ddlExamSeason.SelectedValue = "Sum";
}
else
{
ddlExamSeason.SelectedValue = "Win";
}
lblSeasonHidden.Text = ddlExamSeason.SelectedValue.ToString() + "" + txtYearSeason.Text.ToString();
txtYearSeason.Text = DateTime.Now.Year.ToString();
lblSeasonHidden.Text = ddlExamSeason.SelectedValue.ToString() + "" + txtYearSeason.Text.ToString();
ddlExamSeason.Focus();
PanView.Visible = false;
panView5.Visible = false;
}
}
catch (NullReferenceException ex)
{
Response.Redirect("../Login.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"]) == null)
{
Response.Redirect("../Login.aspx");
}
if (!IsPostBack)
{
maikal dev = new maikal();
int se = dev.chksession();
if (se == 0)
{
ddlsession.SelectedValue = "Sum";
}
else
{
ddlsession.SelectedValue = "Win";
}
txtSession.Text = DateTime.Now.Year.ToString();
lblSessionHiddend.Text = ddlsession.SelectedValue.ToString() + "" + txtSession.Text.ToString();
ddlbindSearch();
bindddlApptype();
ddlsession.Focus();
con.Close(); con.Dispose();
}
}
catch (NullReferenceException ex)
{
Response.Redirect("../Login.aspx");
}
finally
{
}
}
protected void lblHomeRedirect_Click(object sender, EventArgs e)
{
try
{
maikal m = new maikal();
int lvl = m.returnlevel(Server.HtmlEncode(Request.Cookies["MyLogin"]["UID"]).ToString(), Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"]).ToString());
if (lvl == 0)
{
Response.Redirect("../SuperAdmin.aspx?" + Request.Cookies["redic"].Value.ToString());
}
else if (lvl == 1)
{
Response.Redirect("../SuperAdmin.aspx?" + Request.Cookies["redic"].Value.ToString());
}
else if (lvl == 2)
{
Response.Redirect("../UserHome.aspx?" + Request.Cookies["redic"].Value.ToString());
}
}
catch (NullReferenceException ex)
{
Response.Redirect("../Login.aspx");
}
}
protected void imgbtnRecover_Click(object sender, ImageClickEventArgs e)
{
try
{
maikal mk = new maikal();
int lvl = mk.returnlevel(Server.HtmlEncode(Request.Cookies["MyLogin"]["UID"]).ToString(), Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"]).ToString());
if (lvl == 0 & (Request.QueryString["lnk"].ToString() != "null"))
{
Response.Redirect("../Admin/AdminCreate.aspx?lnk=update&lvl=zerotyp=Admin");
}
else if (lvl == 1 | (Request.QueryString["lnk"].ToString() == "null"))
{
Response.Redirect("../User/Create.aspx?lnk=update&lvl=one&typ=" + Request.QueryString["typ"].ToString() + "");
}
else
{
}
}
catch (NullReferenceException ex)
{
Response.Redirect("../Login.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"]) == null)
{
Response.Redirect("../Login.aspx");
}
else
{
}
if (!IsPostBack)
{
ddlExamSeason.Focus();
pnlSupplier.Visible = false;
pnlProspectus.Visible = false;
txtYear.Text = DateTime.Now.Year.ToString();
maikal dev = new maikal();
int se = dev.chksession();
if (se == 0)
{
ddlExamSeason.SelectedValue = "Sum";
}
else
{
ddlExamSeason.SelectedValue = "Win"; // lblFromName.Text = "Membership No:";
}
lblHiddenSeason.Text = ddlExamSeason.SelectedValue.ToString() + "" + txtYear.Text.ToString();
pnlList.Visible = false;
}
}
catch (NullReferenceException ex)
{
Response.Redirect("../Login.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"])) == "")
{
Response.Redirect("../Login.aspx");
}
if (!IsPostBack)
{
txtYearSeason.Text = DateTime.Now.Year.ToString();
maikal mk = new maikal();
int sn = mk.chksession();
if (sn == 0)
{
ddlExamSeason.SelectedValue = "Sum";
}
else
{
ddlExamSeason.SelectedValue = "Win";
}
lblHiddenSeason.Text = ddlExamSeason.SelectedValue.ToString() + "" + txtYearSeason.Text.ToString();
bindPaperCode();
ddlExamSeason.Focus();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"]) == null)
{
Response.Redirect("../Login.aspx");
}
else
{
if (!IsPostBack)
{
pnlmain.Visible = false;
maikal dev = new maikal();
int se = dev.chksession();
if (se == 0)
{
ddlsession.SelectedValue = "Sum";
}
else
{
ddlsession.SelectedValue = "Win";
}
txtSession.Text = DateTime.Now.Year.ToString();
lblSessionHiddend.Text = ddlsession.SelectedValue.ToString() + "" + txtSession.Text.ToString();
ddlsession.Focus();
txtDate.Text = DateTime.Now.ToString("dd/MM/yyyy");
bindgrid();
}
}
}
catch (NullReferenceException ex)
{
Response.Redirect("../Login.aspx");
}
}
protected void lblHomeRedirect_Click(object sender, EventArgs e)
{
try
{
maikal mk = new maikal();
int lvl = mk.returnlevel(MyLogin.login[1].ToString(), MyLogin.login[0].ToString());
if (lvl == 0)
{
Response.Redirect("../SuperAdmin.aspx?" + Request.Cookies["redic"].Value.ToString());
}
else if (lvl == 1)
{
Response.Redirect("../SuperAdmin.aspx?" + Request.Cookies["redic"].Value.ToString());
}
else if (lvl == 2)
{
Response.Redirect("../UserHome.aspx?" + Request.Cookies["redic"].Value.ToString());
}
}
catch (NullReferenceException ex)
{
Response.Redirect("../Login.aspx");
}
}
protected void imgbtnCreate_Click(object sender, ImageClickEventArgs e)
{
try
{
maikal mk = new maikal();
int lvl = mk.returnlevel(Server.HtmlEncode(Request.Cookies["MyLogin"]["UID"]).ToString(), Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"]).ToString());
if (lvl == 0)
{
Response.Redirect("Admin/AdminCreate.aspx?lnk=create&lvl=zero&typ=Admin");
}
else if (lvl == 1)
{
Response.Redirect("User/Create.aspx?lnk=create&lvl=one");
}
else
{
}
}
catch (NullReferenceException ex)
{
Response.Redirect("Login.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"])) == "")
{
Response.Redirect("../Login.aspx");
}
else
{
if (!IsPostBack)
{
maikal dev = new maikal();
ecity.getItems(ddlExamCity);
ecity.getItems(ddlExamCity2);
int se = dev.chksession();
if (se == 0)
{
ddlExamSeason.SelectedValue = "Sum";
}
else
{
ddlExamSeason.SelectedValue = "Win";
}
txtYearSeason.Text = DateTime.Now.Year.ToString();
lblExamSeasonHidden.Text = ddlExamSeason.SelectedValue.ToString() + "" + txtYearSeason.Text.ToString();
sd = new SessionDuration();
lblSessionID.Text = sd.SessionToSessionID(lblExamSeasonHidden.Text.ToString()).ToString();
}
}
}
catch (NullReferenceException ex)
{
Response.Redirect("../Login.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"])) == "")
{
Response.Redirect("../Login.aspx");
}
else
{
VerifyRenderingInServerForm(this);
if (!IsPostBack)
{
txtYear.Text = DateTime.Now.Year.ToString();
maikal mk = new maikal();
int sn = mk.chksession();
if (sn == 0)
{
ddlSessionSelect.SelectedValue = "Sum";
}
else
{
ddlSessionSelect.SelectedValue = "Win";
}
lblSessionHidden.Text = ddlSessionSelect.SelectedValue.ToString() + "" + txtYear.Text.ToString();
ddlSessionSelect.Focus();
grviti.DataSource = disp(); grviti.DataBind();
panRollNo.Visible = true;
}
}
}
catch (NullReferenceException ex)
{
Response.Redirect("../Login.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"]) == null)
{
Response.Redirect("../Login.aspx");
}
string IMID = Request.QueryString["acid"];
string DNo = Request.QueryString["DNo"];
if (!IsPostBack)
{
ClsEdit clEdit = new ClsEdit();
string[] stredit = clEdit.EditCount("DDEntry");
lblEditCount.Text = stredit[0].ToString();
if (stredit[1] == "False")
{
pnlEdit.Enabled = false;
}
else
{
pnlEdit.Enabled = true;
}
btnSubmitAmt.Enabled = false;
maikal dev = new maikal();
int se = dev.chksession();
if (se == 0)
{
ddlsession.SelectedValue = "Sum";
}
else
{
ddlsession.SelectedValue = "Win";
}
txtSession.Text = DateTime.Now.Year.ToString();
lblhiddenSession.Text = ddlsession.SelectedValue.ToString() + "" + txtSession.Text.ToString();
if (IMID != null || DNo != null)
{
txtIDIM.Text = IMID;
txtDiaryNo.Text = DNo;
View();
}
else
{
txtIDIM.Text = "";
txtDiaryNo.Text = "";
}
lblDDNNO.Text = "DD No:";
lblAccountNo.Text = "Diary No:";
pnlIMInfo.Visible = false;
txtDDNO.Visible = true; txtDiaryNo.Visible = true;
totalamt.Visible = false; panelCourier.Visible = false;
ddlsession.Focus();
LoadDropdownList();
}
}
catch (NullReferenceException ex)
{
txtIDIM.Enabled = false;
Response.Redirect("../Login.aspx");
}
finally
{
}
}
private void centerinfo(string code, string session)
{
lblSeasonHidden.Text = ddlExamSeason.SelectedValue.ToString() + "" + txtYearSeason.Text.ToString();
SqlCommand cmd = new SqlCommand("select * from ExamCenter where ID='" + code + "' and Season='" + lblSeasonHidden.Text.ToString() + "'", con);
SqlDataReader reader;
reader = cmd.ExecuteReader();
if (reader.Read())
{
lblCenterCode.Text = reader["ID"].ToString();
lblCenteNaem.Text = reader["Name"].ToString();
lblCenterAddress.Text = reader["Address"].ToString();
lblCenterAddress2.Text = reader["Address2"].ToString();
lblCenterCity.Text = reader["City"].ToString();
lblCenterState.Text = reader["State"].ToString();
lblPinCode.Text = reader["Pin"].ToString();
lblExceptionCode.Text = "";
reader.Close();
SqlCommand cmd1 = new SqlCommand("select * from ExamCenter where ID='" + lblCenterCode.Text + "'", con);
SqlDataReader read = cmd1.ExecuteReader();
while (read.Read())
{
sea = read["Season"].ToString();
}
read.Close();
read.Dispose(); string yr = DateTime.Now.Year.ToString();
maikal dev = new maikal();
int se = dev.chksession();
if (se == 0)
{
season = "Sum" + yr;
}
else
{
season = "Win" + yr;
}
if (sea == season)
{
btnAdd.Visible = false;
}
else if (sea != season)
{
btnAdd.Visible = true;
}
}
else
{
lblExceptionCode.Text = "Invalid Exam Center Code";
pnlAcInf.Visible = false; panView5.Visible = false; PanView.Visible = false;
}
reader.Close();
cmd = new SqlCommand("select Sum(Capacity) from Rooms where ID='" + txtExamCode.Text.ToString() + "' and Season='" + lblSeasonHidden.Text.ToString() + "'", con);
string sum = Convert.ToString(cmd.ExecuteScalar());
if (sum == "")
{
lblCapacity.Text = "0";
}
{
lblCapacity.Text = sum.ToString();
}
}
protected void btnshow_Click(object sender, EventArgs e)
{
maikal dev = new maikal();
dtinfo.ShortDatePattern = "dd/MM/yyyy";
dtinfo.DateSeparator = "/";
txtName.Focus(); con.Close(); con.Open();
cmd = new SqlCommand("select ID,Name,Address,Address2,City,State,Pincode,Contact,Mobile,Email,RegisDate,Session,Type,CivilPartII,CivilSectionB,ArchiPartII,ArchiSectionB,Person,Designation,HOD from InstitutionReg where Name='" + dropname.SelectedItem.Text.ToString() + "' and ID='" + lblEnrolment.Text + "'", con);
SqlDataReader dr;
dr = cmd.ExecuteReader();
if (dr.Read() == true)
{
Panel1.Visible = true; Panel2.Visible = false;
txtName.Text = dr["Name"].ToString(); txtAdd1.Text = dr["Address"].ToString(); txtAdd2.Text = dr["Address2"].ToString(); ddlCity.SelectedItem.Text = dr["City"].ToString();
ddlState.SelectedItem.Text = dr["State"].ToString(); txtPPincode.Text = dr["Pincode"].ToString(); txtPhoneNo.Text = dr["Contact"].ToString(); txtMobile.Text = dr["Mobile"].ToString(); txtEmail.Text = dr["Email"].ToString();
if (dr["RegisDate"] == DBNull.Value)
{
txtreg.Text = "";
}
else
{
txtreg.Text = Convert.ToDateTime(dr["RegisDate"]).ToString("dd/MM/yyyy");
}
string str1 = dr["Session"].ToString(); str1 = str1.Substring(0, 3); ddlsession.SelectedValue = str1;
str1 = dr["Session"].ToString(); str1 = str1.Substring(3, 4); txtSession.Text = str1.ToString();
string str2 = dr["Type"].ToString(); str2 = str2.Substring(0, 3); ddlsession3.SelectedValue = str2;
str2 = dr["Type"].ToString(); str2 = str2.Substring(3, 4); txtSession3.Text = str2.ToString();
lblSessionHiddend.Text = ddlsession.SelectedValue.ToString() + "" + txtSession.Text.ToString();
lblSession.Text = ddlsession3.SelectedValue.ToString() + "" + txtSession3.Text.ToString();
string strchkCPartII = dr["CivilPartII"].ToString(); if (strchkCPartII == "YES")
{
chkCPartII.Checked = true;
}
else
{
chkCPartII.Checked = false;
}
string strchkCSectionB = dr["CivilSectionB"].ToString(); if (strchkCSectionB == "YES")
{
chkCSectionB.Checked = true;
}
else
{
chkCSectionB.Checked = false;
}
string strchkAPartII = dr["ArchiPartII"].ToString(); if (strchkAPartII == "YES")
{
chkAPartII.Checked = true;
}
else
{
chkAPartII.Checked = false;
}
string strchkASectionB = dr["ArchiSectionB"].ToString(); if (strchkASectionB == "YES")
{
chkASectionB.Checked = true;
}
else
{
chkASectionB.Checked = false;
}
txtPerson.Text = dr["Person"].ToString();
txtDesig.Text = dr["Designation"].ToString();
txtHOD.Text = dr["HOD"].ToString();
}
dr.Close(); con.Close(); con.Dispose();
}
protected void btnSAve_Onclick(object sender, EventArgs e)
{
try
{
con.Close(); con.Open();
SqlCommand cmd = new SqlCommand();
int x = 0, y = 0, w = 0; string v = "";
int amount = Convert.ToInt32(txtRefund.Text);
string str = "select IMID,Total,Credit,GID,GTotal from IMAC where IMID='" + lblEnrolment.Text.ToString() + "' ";
cmd = new SqlCommand(str, con);
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
x = Convert.ToInt32(rd["Credit"]);
y = Convert.ToInt32(rd["LateFeeTaken"]);
w = Convert.ToInt32(rd["GTotal"]);
v = (rd["GID"]).ToString();
w = w - x - y;
}
rd.Close();
string str1 = "update IMAC set Total=@imactotal,Credit=@credit where IMID='" + lblEnrolment.Text + "'";
cmd = new SqlCommand(str1, con);
cmd.Parameters.AddWithValue("@imactotal", 0);
cmd.Parameters.AddWithValue("@credit", 0);
cmd.ExecuteNonQuery();
string str2 = "update IMAC set GTotal=@gtotal where GID='" + v + "'";
cmd = new SqlCommand(str2, con);
cmd.Parameters.AddWithValue("@gtotal", w);
cmd.ExecuteNonQuery();
maikal dev = new maikal();
int se = dev.chksession(); string session;
if (se == 0)
{
session = "Sum";
}
else
{
session = "Win";
}
session = session + DateTime.Now.Year.ToString();
ClsAccount cl = new ClsAccount();
cl.AmountSubmit(lblEnrolment.Text.ToString(), "", DateTime.Now, "Debit", lblToAmt.Text.ToString(), session.ToString(), "Membership ReFund");
cmd = new SqlCommand("select max(TransID) from MemberFee where ID='" + lblEnrolment.Text.ToString() + "'", con);
string tid = Convert.ToString(cmd.ExecuteScalar());
cmd = new SqlCommand("insert into MemberFee (MType, ID, Amt, FeeType, SubDate, SubType, AcountNo, DD, Bank, YearFrom, YearTo,TransType,Balance,TransID) values(@MType, @ID, @Amt, @FeeType, @SubDate, @SubType, @AcountNo, @DD, @Bank, @YearFrom, @YearTo, @TransType, @Balance,@TransID)", con);
cmd.Parameters.AddWithValue("@MType", "IM");
cmd.Parameters.AddWithValue("@ID", lblEnrolment.Text.ToString());
cmd.Parameters.AddWithValue("@Amt", txtRefund.Text);
cmd.Parameters.AddWithValue("@FeeType", "Membership ReFund");
cmd.Parameters.AddWithValue("@SubDate", Convert.ToDateTime(DateTime.Now, dtinfo));
cmd.Parameters.AddWithValue("@SubType", "N/A");
cmd.Parameters.AddWithValue("@AcountNo", "N/A");
cmd.Parameters.AddWithValue("@DD", "N/A");
cmd.Parameters.AddWithValue("@Bank", "N/A");
cmd.Parameters.AddWithValue("@YearFrom", session);
cmd.Parameters.AddWithValue("@YearTo", "");
cmd.Parameters.AddWithValue("@TransType", "Credit");
cmd.Parameters.AddWithValue("@Balance", 0);
cmd.Parameters.AddWithValue("@TransID", tid + 1);
cmd.ExecuteNonQuery();
cmd = new SqlCommand("update IMInspection set Status=@Status,Refund=@Refund,TotalAmount=@TotalAmount where ID='" + lblEnrolment.Text.ToString() + "' and SN='" + GridView2.SelectedRow.Cells[1].Text.ToString() + "'", con);
cmd.Parameters.AddWithValue("@Status", "ReFund");
cmd.Parameters.AddWithValue("@Refund", txtRefund.Text.ToString());
cmd.Parameters.AddWithValue("@TotalAmount", lblToAmt.Text.ToString());
cmd.ExecuteNonQuery();
lblException.Text = "Refund Amount Saved.";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "success", "alert('Refund Amount Saved.')", true);
con.Close();
con.Dispose();
}
catch (Exception ex)
{
}
}
protected void btnRegister_Click(object sender, EventArgs e)
{
dtinfo.ShortDatePattern = "dd/MM/yyyy";
dtinfo.DateSeparator = "/";
try
{
ddno = txtdiary.Text.ToString();
con.Close();
con.Open();
string imid = genid();
SqlCommand cmd = new SqlCommand("Insert into Member(Name,LName,Designation,Email,ID,HQualification,Experience,Type,Active,RegDate,RenewDate,ExpDate,YearFrom,YearTo,ExpStatus) Values(@Name,@LName,@Designation,@Email,@ID,@HQualification,@Experience,@Type,@Active,@RegDate,@RenewDate,@ExpDate,@YearFrom,@YearTo,@ExpStatus)", con);
//SqlCommand cmd = new SqlCommand("Insert into Member(Name,LName,Designation,Email,ID,HQualification,Experience,Type,Active,RegDate,YearFrom,YearTo,ExpStatus) Values(@Name,@LName,@Designation,@Email,@ID,@HQualification,@Experience,@Type,@Active,@RegDate,@YearFrom,@YearTo,@ExpStatus)", con);
cmd.Parameters.AddWithValue("@Name", txtNaem.Text.ToString());
cmd.Parameters.AddWithValue("@LName", "");
cmd.Parameters.AddWithValue("@Designation", txtDesignation.Text.ToString());
cmd.Parameters.AddWithValue("@Email", txtEmail.Text.ToString());
cmd.Parameters.AddWithValue("@ID", imid.ToString());
cmd.Parameters.AddWithValue("@HQualification", "Education");
cmd.Parameters.AddWithValue("@Experience", "Experience");
if (rbtnHFellow.Checked == true)
{
cmd.Parameters.AddWithValue("@Type", "Honorary");
}
else if (rbtnFellow.Checked == true)
{
cmd.Parameters.AddWithValue("@Type", "Fellow");
}
else if (rbtMember.Checked == true)
{
cmd.Parameters.AddWithValue("@Type", "Member");
}
else
{
cmd.Parameters.AddWithValue("@Type", "IM");
}
cmd.Parameters.AddWithValue("@Active", "Register");
string dateEnroll = System.DateTime.Now.ToShortDateString();
cmd.Parameters.AddWithValue("@RegDate", Convert.ToDateTime(dateEnroll.ToString()));
cmd.Parameters.AddWithValue("@RenewDate", Convert.ToDateTime(dateEnroll.ToString()).AddYears(1));
cmd.Parameters.AddWithValue("@ExpDate", Convert.ToDateTime(dateEnroll.ToString()).AddYears(1).AddMonths(6));
maikal dev = new maikal();
int se = dev.chksession();
string ssn = ""; int yr = DateTime.Now.Year;
if (se == 0)
{
ssn = "Sum";
}
else
{
ssn = "Win";
}
cmd.Parameters.AddWithValue("@YearFrom", ssn + "" + yr.ToString());
cmd.Parameters.AddWithValue("@YearTo", ssn + "" + (yr + 1).ToString());
cmd.Parameters.AddWithValue("@ExpStatus", 0);
lblstep1.ForeColor = System.Drawing.Color.Green;
lblStep2.ForeColor = System.Drawing.Color.Black;
btnRegister.Enabled = false;
panelNewMem.Visible = true;
btnViewProfile.Visible = true; Stripview.Visible = true;
btnViewProfile.Text = "View Profile";
lblstep1.Visible = true; lblStep2.Visible = true;
cmd.ExecuteNonQuery();
SqlCommand cmd1 = new SqlCommand("update DiaryEntry set Status='Blocked',IMID='" + imid.ToString() + "',MembershipNo='" + imid.ToString() + "' where DiaryNo='" + ddno + "'", con);
cmd1.ExecuteNonQuery();
SqlCommand cm = new SqlCommand("update DairyCount set IMID='" + imid.ToString() + "' where DairyNo='" + ddno + "'", con);
cm.ExecuteNonQuery();
}
catch (SqlException ex)
{
lblException.Text = ex.ToString();
btnViewProfile.Visible = false;
}
finally
{
con.Close();
con.Dispose();
}
}
protected void txtSName_TExtChnaged(object sender, EventArgs e)
{
maikal mk = new maikal();
if (ddlRecivefrom.SelectedValue == "IM")
{
string strimsts = mk.SearchProfile(txtSName.Text.ToString());
if (strimsts == "")
{
btnSaveDiary.Enabled = false;
lblExceptiontbl.Text = "Invalid IM Membership No."; txtSName.Focus(); formstatus = "No";
lblName.Text = ""; txtSName.Text = "";
lblCode.Text = ""; lblCourseAddress.Text = "";
}
else
{
btnSaveDiary.Enabled = true;
lblExceptiontbl.Text = ""; formstatus = "Yes";
con.Close(); con.Open();
SqlCommand cmd = new SqlCommand("select * from IM where ID='" + txtSName.Text.ToString() + "'", con);
SqlDataReader reader;
reader = cmd.ExecuteReader();
while (reader.Read())
{
lblName.Text = reader["Name"].ToString();
lblCode.Text = "City: " + reader["PCity"].ToString();
lblCourseAddress.Text = "Status: " + reader["Active"].ToString();
}
reader.Close();
con.Close();
con.Dispose();
txtDate.Focus();
}
}
else if (ddlRecivefrom.SelectedValue == "Student")
{
string[] stdsts = new string[2];
Student std = new Student();
stdsts = std.status(txtSName.Text.ToString());
if (stdsts[1].ToString() == "No")
{
lblExceptiontbl.Text = "Invalid Student Membership No"; txtSName.Text = "";
formstatus = "No"; txtSName.Focus();
btnSaveDiary.Enabled = false;
}
else
{
btnSaveDiary.Enabled = true;
bool bl = mk.chkstatusStu(txtSName.Text.ToString());
if (bl == false)
{
lblExceptiontbl.Text = "Student Membership Not Activated"; formstatus = "No"; txtSName.Focus();
}
else
{
lblExceptiontbl.Text = ""; formstatus = "Yes";
con.Close(); con.Open();
SqlCommand cmd = new SqlCommand("select * from Student where SID='" + txtSName.Text.ToString() + "'", con);
SqlDataReader reader;
reader = cmd.ExecuteReader();
while (reader.Read())
{
lblName.Text = "Student Name: " + reader["Name"].ToString();
lblCode.Text = "City: " + reader["PCity"].ToString();
lblCourseAddress.Text = "Status: " + reader["Status"].ToString();
}
reader.Close();
con.Close();
con.Dispose();
txtDate.Focus();
}
}
}
else if (ddlRecivefrom.SelectedValue == "Other")
{
ddlRecivefrom.Focus();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"])) == "")
{
Response.Redirect("../Login.aspx");
}
if (!IsPostBack)
{
showimg();
try
{
SqlDataReader reader;
con.Open();
lbtnUserName.Text = Convert.ToString(Request.QueryString["dev"]);
SqlCommand cmd = new SqlCommand("select * from Login where LogName='" + Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["UID"])) + "' and Password='******'", con);
reader = cmd.ExecuteReader();
if (reader.Read())
{
lbtnUserName.Text = Convert.ToString(reader[1].ToString());
int lvl = Convert.ToInt32(reader[20].ToString());
if (lvl == 0)
{
lblWelcome.Text = "Administrator";
}
else if (lvl == 1)
{
lblWelcome.Text = "Admin";
panelUpdate.Visible = false;
}
else if (lvl == 2)
{
panelExamForm.Visible = false; panelSeatingArrangement.Visible = false; panelDegree.Visible = false; panelPaperSetter.Visible = false;
panelExamPaper.Visible = false; panelMarksFeed.Visible = false; PanelAdmitCard.Visible = false; PanelRollNo.Visible = false; panelExamSchedule.Visible = false;
panelCertificate.Visible = false; panelExamCenter.Visible = false; panelMarking.Visible = false; panelUFM.Visible = false; panelRechecking.Visible = false;
panelUpdate.Visible = false;
lblWelcome.Text = "User ID";
usermanage.Visible = false;
if (reader["ExamForm"].ToString() == "ExamForm")
{
panelExamForm.Visible = true;
}
if (reader["Seating"].ToString() == "Seating")
{
panelSeatingArrangement.Visible = true;
}
if (reader["Marksheet"].ToString() == "Marksheet")
{
panelDegree.Visible = true;
}
if (reader["PaperSetter"].ToString() == "PaperSetter")
{
panelPaperSetter.Visible = true;
}
if (reader["ExamPaper"].ToString() == "ExamPaper")
{
panelExamPaper.Visible = true;
}
if (reader["MarksFeed"].ToString() == "MarksFeed")
{
panelMarksFeed.Visible = true;
}
if (reader["AdmitCard"].ToString() == "AdmitCard")
{
PanelAdmitCard.Visible = true;
}
if (reader["RollNO"].ToString() == "RollNO")
{
PanelRollNo.Visible = true;
}
if (reader["ExamAdmin1"].ToString() == "ExamSchedule")
{
panelExamSchedule.Visible = true;
}
if (reader["Certi"].ToString() == "Certi")
{
panelCertificate.Visible = true;
}
if (reader["ExamCenter"].ToString() == "ECenter")
{
panelExamCenter.Visible = true;
}
if (reader["Marking"].ToString() == "Marking")
{
panelMarking.Visible = true;
}
if (reader["UFM"].ToString() == "UFM")
{
panelUFM.Visible = true;
}
if (reader["Rechecking"].ToString() == "Rechecking")
{
panelRechecking.Visible = true;
}
}
}
reader.Close();
reader.Dispose();
maikal dev = new maikal();
int se = dev.chksession();
if (se == 0)
{
ddlSession.SelectedValue = "Sum";
}
else
{
ddlSession.SelectedValue = "Win";
}
txtYear.Text = DateTime.Now.Year.ToString();
sd = new SessionDuration();
SeasonId.Text = sd.SessionToSessionID(ddlSession.SelectedValue.ToString() + "" + txtYear.Text.ToString()).ToString();
ddlSession.Focus();
this.Session["UploadDetail"] = new UploadDetail {
IsReady = false
};
LoadUploadedFiles(ref gvNewFiles);
con.Close(); con.Dispose();
}
catch (SqlException ex)
{
lblWelcome.Text = "Error";
}
}
}
catch (NullReferenceException ex)
{
Response.Redirect("../Login.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"])) == "")
{
Response.Redirect("../Login.aspx");
}
if (!IsPostBack)
{
con.Open();
btnSave.Enabled = false;
txtYearSeason.Text = DateTime.Now.Year.ToString();
maikal mk = new maikal();
int sn = mk.chksession();
if (sn == 0)
{
ddlExamSeason.SelectedValue = "Sum";
}
else
{
ddlExamSeason.SelectedValue = "Win";
}
lblHiddenSeason.Text = ddlExamSeason.SelectedValue.ToString() + "" + txtYearSeason.Text.ToString();
ddlCourse.SelectedValue = "Civil";
ddlPart.SelectedValue = "PartI";
string qyry = "";
if (ddlCourse.SelectedValue.ToString() == "Civil")
{
qyry = "select distinct CourseID from CivilSubMaster";
}
else if (ddlCourse.SelectedValue.ToString() == "Architecture")
{
qyry = "select distinct CourseID from ArchiSubMaster";
}
SqlDataAdapter ad = new SqlDataAdapter(qyry, con);
DataSet ds = new DataSet();
ad.Fill(ds);
ddlSyllabus.DataSource = ds;
ddlSyllabus.DataTextField = "CourseID";
ddlSyllabus.DataValueField = "CourseID";
ddlSyllabus.DataBind();
showcourse();
details();
GridMarks.DataSource = grid();
GridMarks.DataBind();
if (GridMarks.Rows.Count == 0)
{
btnSave.Enabled = false;
}
else
{
btnSave.Enabled = true;
}
ddlExamSeason.Focus();
con.Close(); con.Dispose();
}
}
catch (NullReferenceException ex)
{
Response.Redirect("../Login.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try{
if (Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"])) == "")
{
Response.Redirect("../Login.aspx");
}
else
{
if (!IsPostBack)
{
btnSave.Enabled = false;
txtPSetterCode.Visible = false;
txtPSetterName.Visible = false;
gettime(); lblStreamHidden.Text = "Tech"; lblStreamName.Text = "Technician Engineering";
txtyear.Text = DateTime.Now.Year.ToString();
maikal dev = new maikal();
int se = dev.chksession();
if (se == 0)
{
ddlExamSeason.SelectedValue = "Sum";
}
else
{
ddlExamSeason.SelectedValue = "Win";
}
lblSeason.Text = ddlExamSeason.SelectedValue.ToString() + "" + txtyear.Text.ToString();
btnDeleteRow.Visible = false;
string qry = "";
ddlCourse.SelectedValue = "Civil";
if (ddlCourse.SelectedValue.ToString() == "Civil")
{
panelAsso.Visible = false;
panelTech.Visible = true;
qry = "select Distinct CourseID from CivilSubMaster";
}
else if (ddlCourse.SelectedValue.ToString() == "Architecture")
{
panelAsso.Visible = true;
panelTech.Visible = false;
qry = "select Distinct CourseID from ArchiSubMaster";
}
SqlDataAdapter ad = new SqlDataAdapter(qry, con);
DataSet ds = new DataSet();
ad.Fill(ds);
ddlSyllabus.DataSource = ds;
ddlSyllabus.DataTextField = "CourseID";
ddlSyllabus.DataValueField = "CourseID";
ddlSyllabus.DataBind();
FeeMaster fm = new FeeMaster();
ddlSyllabus.SelectedValue = fm.currentCourse(ddlCourse.SelectedValue.ToString());
ddlType.Focus();
}
}
}
catch (NullReferenceException ex)
{
Response.Redirect("../Login.aspx");
}
}
