protected void ibtnExportPDFAppTableDoc_Click(object sender, ImageClickEventArgs e)
{
GridAppTable.AllowPaging = false;
GridAppTable.DataSource = grid();
GridAppTable.DataBind();
if (GridAppTable.Rows.Count > 0)
{
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition",
"attachment;filename=ApprovedMembership.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridAppTable.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();
}
}
protected void ddlPart_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlCourse.SelectedValue.ToString() == "Civil")
{
if (ddlPart.SelectedValue.ToString() == "PartI")
txtNOOfForms.Text = lblToPart1.Text;
else if (ddlPart.SelectedValue.ToString() == "PartII")
txtNOOfForms.Text = lbltoPartII.Text;
else if (ddlPart.SelectedValue.ToString() == "SectionA")
txtNOOfForms.Text = lblToSectionA.Text;
else if (ddlPart.SelectedValue.ToString() == "SectionB")
txtNOOfForms.Text = lblToSectinB.Text;
}
else
{
if (ddlPart.SelectedValue.ToString() == "PartI")
txtNOOfForms.Text = lblToPPPartI.Text;
else if (ddlPart.SelectedValue.ToString() == "PartII")
txtNOOfForms.Text = lblToPPartII.Text;
else if (ddlPart.SelectedValue.ToString() == "SectionA")
txtNOOfForms.Text = lblToSSectionA.Text;
else if (ddlPart.SelectedValue.ToString() == "SectionB")
txtNOOfForms.Text = lblToSSectinB.Text;
}
GridAppTable.DataSource=GetDataSource1();
GridAppTable.DataBind();
TotalRecord.Text = GridAppTable.Rows.Count.ToString();
onstartrollno();
txtNOOfForms.Focus();
}
protected void btnView_Onclick(object sender, EventArgs e)
{
string qry = "", qry2 = "";
if (ddlViewBy.SelectedValue.ToString() == "Course")
{
if (ddlCourse.SelectedValue.ToString() == "All")
{
if (ddlStatus.SelectedValue.ToString() == "Active")
{
qry = "select SN,IMID,SID,Name,FName,Course,Part,DOB,AppId,Session,Status from Student where Course='" + ddlCourse.SelectedValue.ToString() + "' and Part='" + ddlPart.SelectedValue.ToString() + "' and Status='" + ddlStatus.SelectedValue.ToString() + "' and IMID='" + txtIMID.Text + "' and Session='" + lblSeasonHidden.Text + "' order by CONVERT(int, AppId)";
}
else
{
qry = "select SN,IMID,SID,Name,FName,Course,Part,DOB,AppId,Session,Status from Student where Status='" + ddlStatus.SelectedValue.ToString() + "' and Session='" + lblSeasonHidden.Text + "' order by CONVERT(int, AppId)";
}
qry2 = "select SN,IMID,SID,Name,FName,Course,Part,DOB,AppId,Session,Status from Student where Status='ToBeApprove' and Session='" + lblSeasonHidden.Text + "' order by CONVERT(int, AppId)";
}
else
{
if (ddlStatus.SelectedValue.ToString() == "Active")
{
qry = "select SN,IMID,SID,Name,FName,Course,Part,DOB,AppId,Session,Status from Student where Course='" + ddlCourse.SelectedValue.ToString() + "' and Part='" + ddlPart.SelectedValue.ToString() + "' and Status='" + ddlStatus.SelectedValue.ToString() + "' and IMID='" + txtIMID.Text + "' and Session='" + lblSeasonHidden.Text + "' order by CONVERT(int, AppId)";
}
else
{
qry = "select SN,IMID,SID,Name,FName,Course,Part,DOB,AppId,Session,Status from Student where Course='" + ddlCourse.SelectedValue.ToString() + "' and Part='" + ddlPart.SelectedValue.ToString() + "' and Status='" + ddlStatus.SelectedValue.ToString() + "' and Session='" + lblSeasonHidden.Text + "' order by CONVERT(int, AppId)";
}
qry2 = "select SN,IMID,SID,Name,FName,Course,Part,DOB,AppId,Session,Status from Student where Course='" + ddlCourse.SelectedValue.ToString() + "' and Part='" + ddlPart.SelectedValue.ToString() + "' and Status='ToBeApprove' and Session='" + lblSeasonHidden.Text + "' order by CONVERT(int, AppId)";
}
}
else if (ddlViewBy.SelectedValue.ToString() == "IMID")
{
qry = "select SN,IMID,SID,Name,FName,Course,Part,DOB,AppId,Course,Part,Session,Status from Student where IMID='" + txtIMID.Text.ToString() + "' and Status='" + ddlStatus.SelectedValue.ToString() + "' and Session='" + lblSeasonHidden.Text + "' order by CONVERT(int, AppId)";
qry2 = "select SN,IMID,SID,Name,FName,Course,Part,DOB,AppId,Course,Part,Session,Status from Student where IMID='" + txtIMID.Text.ToString() + "' and Status='ToBeApprove' and Session='" + lblSeasonHidden.Text + "' order by CONVERT(int, AppId)";
}
SqlDataAdapter ad = new SqlDataAdapter();
ad = new SqlDataAdapter(qry, con);
DataTable at = new DataTable();
ad.Fill(at);
GridToBeApprove.DataSource = at;
GridToBeApprove.DataBind();
ad = new SqlDataAdapter(qry2, con);
at.Clear();
ad.Fill(at);
GridAppTable.DataSource = at;
GridAppTable.DataBind();
if (GridAppTable.Rows.Count > 0)
{
btnApprove.Enabled = true;
}
else
{
btnApprove.Enabled = false;
}
btnViewa.Focus();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
dtinfo.ShortDatePattern = "dd/MM/yyyy";
dtinfo.DateSeparator = "/";
con.Close(); con.Open();
if ((Convert.ToInt32(lblOthersFormRcv.Text) > Convert.ToInt32(lblOthersFormSub.Text)))
{
SqlCommand cmdnnagar = new SqlCommand("insert into AppRecord(IMID,AppNo,Stream,Course,Part,Name,FName,DOB,DNo,Session,SubDate,Status,FormType,FeeType,Amount,LateFee,Exempted,Enrolment,AdmissionFees,Lavel,CompositeFees,AnnualSubFees,ITIFees,ExamFees,CADFees,underage,DupForm,SID,Exam,ITI,CAD,Project) values(@IMID,@AppNo,@Stream,@Course,@Part,@Name,@FName,@DOB,@DNo,@Session,@SubDate,@Status,@FormType,@FeeType,@Amount,@LateFee,@Exempted,@Enrolment,@AdmissionFees,@Lavel,@CompositeFees,@AnnualSubFees,@ITIFees,@ExamFees,@CADFees,@UnderAge,@DupForm,@SID,@Exam,@ITI,@CAD,@Project)", con);
cmdnnagar.Parameters.AddWithValue("@IMID", lblIMID.Text.ToString());
cmdnnagar.Parameters.AddWithValue("@AppNo", apno().ToString());
cmdnnagar.Parameters.AddWithValue("@Stream", lblStream.Text.ToString());
cmdnnagar.Parameters.AddWithValue("@Course", lblCourse.Text.ToString());
cmdnnagar.Parameters.AddWithValue("@Part", lblPart.Text.ToString());
cmdnnagar.Parameters.AddWithValue("@Name", lblName.Text.ToString());
cmdnnagar.Parameters.AddWithValue("@FName", lblFName.Text.ToString());
cmdnnagar.Parameters.AddWithValue("@DOB", Convert.ToDateTime(lblDOB.Text.ToString(), dtinfo));
cmdnnagar.Parameters.AddWithValue("@DNo", txtDiaryNo.Text.ToString());
cmdnnagar.Parameters.AddWithValue("@Session", lblSessionHiddend.Text.ToString());
cmdnnagar.Parameters.AddWithValue("@SubDate", DateTime.Now);
cmdnnagar.Parameters.AddWithValue("@Status", "NotApproved");
cmdnnagar.Parameters.AddWithValue("@FormType", ddlForms.SelectedValue.ToString());
cmdnnagar.Parameters.AddWithValue("@FeeType", ddlForms.SelectedValue.ToString());
cmdnnagar.Parameters.AddWithValue("@Amount", lblFee.Text);
cmdnnagar.Parameters.AddWithValue("@LateFee", "0");
cmdnnagar.Parameters.AddWithValue("@Exempted", "0");
cmdnnagar.Parameters.AddWithValue("@Enrolment", txtMem.Text.ToString());
cmdnnagar.Parameters.AddWithValue("@AdmissionFees", "0");
cmdnnagar.Parameters.AddWithValue("@Lavel", "0");
cmdnnagar.Parameters.AddWithValue("@CompositeFees", "0");
cmdnnagar.Parameters.AddWithValue("@AnnualSubFees", "0");
cmdnnagar.Parameters.AddWithValue("@ITIFees", "0");
cmdnnagar.Parameters.AddWithValue("@ExamFees", "0");
cmdnnagar.Parameters.AddWithValue("@CADFees", "0");
cmdnnagar.Parameters.AddWithValue("@UnderAge", "NO");
cmdnnagar.Parameters.AddWithValue("@DupForm", "");
cmdnnagar.Parameters.AddWithValue("@CAD", "");
cmdnnagar.Parameters.AddWithValue("@Exam", "");
cmdnnagar.Parameters.AddWithValue("@ITI", "");
cmdnnagar.Parameters.AddWithValue("@Project", "");
cmdnnagar.Parameters.AddWithValue("@SID", txtMem.Text.ToString());
cmdnnagar.ExecuteNonQuery(); updateCount(lblSessionHiddend.Text, txtDiaryNo.Text);
SqlDataAdapter ad = new SqlDataAdapter("select Enrolment,Name,FName,DOB,FormType,FeeType,Amount,DNo,SubDate,AppNo from AppRecord where DNo='" + txtDiaryNo.Text.ToString() + "' order by AppNo DESC", con);
DataTable dt = new DataTable();
ad.Fill(dt);
GridAppTable.DataSource = dt;
GridAppTable.DataBind();
lblMsg.CssClass = "success"; lblMsg.Text = "Successfully Submitted";
}
else
{
lblMsg.Text = "All Forms Already Submitted";
}
btnSubmit.Enabled = false; pnlMain.Visible = false;
txtMem.Text = "";
con.Close();
con.Dispose();
btnView.Focus();
}
protected void btnViewDiary_OnClick(object sendr, EventArgs e)
{
View();
getDiaryAmount();
if (GridAppTable.Rows.Count > 0)
{
GridAppTable.Focus();
}
else
{
ddlAmtType.Focus();
}
}
private void View()
{
SqlDataAdapter adp;
if (txtDDSearch.Text == "")
{
adp = new SqlDataAdapter("select DiaryNo,Amt,DDNO,SubDate,Bank,Narration,DDDate,AmtFor from FeeAC where Session='" + lblhiddenSession.Text.ToString() + "' and DiaryNo='" + txtDiaryNo.Text.ToString() + "' order by SubDate Desc", con);
}
else
{
adp = new SqlDataAdapter("select DiaryNo,Amt,DDNO,SubDate,Bank,Narration,DDDate,AmtFor from FeeAC where Session='" + lblhiddenSession.Text.ToString() + "' and DiaryNo='" + txtDiaryNo.Text.ToString() + "' and DDNO='" + txtDDSearch.Text.ToString() + "' order by SubDate Desc", con);
}
DataTable dt = new DataTable();
adp.Fill(dt);
GridAppTable.DataSource = dt;
GridAppTable.DataBind();
}
protected void btnView_click(object sender, EventArgs e)
{
string qry = "";
if (ddlStatus.SelectedValue.ToString() == "NotApproved" | ddlStatus.SelectedValue.ToString() == "Hold")
{
qry = "select Enrolment,Name,FName,DOB,FormType,FeeType,Amount,DNo,SubDate,AppNo,IMID,Course,Part,Session from AppRecord where FormType='" + ddlAppType.SelectedValue.ToString() + "' and Status='" + ddlStatus.SelectedValue.ToString() + "' and DNo='" + txtDiaryNo.Text.ToString() + "'";
}
else
{
qry = "select Enrolment,Name,FName,DOB,FormType,FeeType,Amount,DNo,SubDate,AppNo,IMID,Course,Part,Session from AppRecord where FormType='" + ddlAppType.SelectedValue.ToString() + "' and Status!='NotApproved' and Status!='Hold' and DNo='" + txtDiaryNo.Text.ToString() + "'";
}
SqlDataAdapter ad = new SqlDataAdapter(qry, con);
DataTable dt = new DataTable();
ad.Fill(dt);
GridAppTable.DataSource = dt;
GridAppTable.DataBind();
btnSubmit.Enabled = true;
}
protected void ibtnExportExcelAppTableDoc_Click(object sender, ImageClickEventArgs e)
{
GridAppTable.AllowPaging = false;
GridAppTable.DataSource = grid();
GridAppTable.DataBind();
if (GridAppTable.Rows.Count > 0)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=ApprovedMembership.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridAppTable.RenderControl(hw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
protected void btnToBeApprove_OnClick(object sender, EventArgs e)
{
btnApprove.Enabled = true;
con.Close(); con.Open();
SqlCommand cmd = new SqlCommand();
for (int i = 0; i < GridToBeApprove.Rows.Count; i++)
{
CheckBox chk = (CheckBox)GridToBeApprove.Rows[i].FindControl("chkapp");
if (chk.Checked)
{
cmd = new SqlCommand("update Student set Status=@Status where SN='" + Convert.ToInt32(GridToBeApprove.Rows[i].Cells[2].Text.ToString()) + "'", con);
cmd.Parameters.AddWithValue("@Status", "ToBeApprove");
cmd.ExecuteNonQuery();
}
}
GridAppTable.DataSource = GetDataSource();
GridAppTable.DataBind();
con.Close();
con.Dispose();
btnToBeApprove.Focus();
}
protected void btnView_Click(object sender, EventArgs e)
{
SqlDataAdapter ad = new SqlDataAdapter();
if (ddlFormType.SelectedValue == "Exam")
{
ad = new SqlDataAdapter("select Name,FName,DOB,FormType,FeeType,Amount,LateFee,Exempted,Enrolment,AdmissionFees,CompositeFees,AnnualSubFees,ITIFees,ExamFees,CADFees,DupForm,AppNo,Status,Course,Part,IMID,Exam,DNo from AppRecord where Session='" + lblSeasonHidden.Text.ToString() + "' and Enrolment='" + txtSID.Text.ToString() + "' and ExamFees!=0 ORDER BY SN DESC", con);
}
else if (ddlFormType.SelectedValue == "Admission")
{
ad = new SqlDataAdapter("select Name,FName,DOB,FormType,FeeType,Amount,LateFee,Exempted,Enrolment,AdmissionFees,CompositeFees,AnnualSubFees,ITIFees,ExamFees,CADFees,DupForm,AppNo,Status,Course,Part,IMID,Exam ,DNo from AppRecord where Session='" + lblSeasonHidden.Text.ToString() + "' and Enrolment='" + txtSID.Text.ToString() + "' and AdmissionFees!=0 ORDER BY SN DESC", con);
}
else
{
ad = new SqlDataAdapter("select Name,FName,DOB,FormType,FeeType,Amount,LateFee,Exempted,Enrolment,AdmissionFees,CompositeFees,AnnualSubFees,ITIFees,ExamFees,CADFees,DupForm,AppNo,Status,Course,Part,IMID,Exam ,DNo from AppRecord where Session='" + lblSeasonHidden.Text.ToString() + "' and Enrolment='" + txtSID.Text.ToString() + "' and AdmissionFees!=0 ORDER BY SN DESC", con);
}
DataTable dt = new DataTable();
ad.Fill(dt);
GridAppTable.DataSource = dt;
GridAppTable.DataBind();
panelFee1.Visible = false;
panelFee2.Visible = false;
}
protected void btnGenerateRollNo_Click(object sender, EventArgs e)
{
int a = Convert.ToInt32(StartRol.Text.ToString());
int count = a;
con.Close(); con.Open();
for (int i = 0; i <= GridAppTable.Rows.Count - 1; i++)
{
SqlCommand cmd = new SqlCommand("update ExamForms set Status=@Status,RollNo=@RollNo where SID='" + GridAppTable.Rows[i].Cells[0].Text.ToString() + "' and Status='" + GridAppTable.Rows[i].Cells[1].Text.ToString() + "' and ExamSeason='" + GridAppTable.Rows[i].Cells[2].Text.ToString() + "' and IMID='" + GridAppTable.Rows[i].Cells[3].Text.ToString() + "' and Course='" + GridAppTable.Rows[i].Cells[4].Text.ToString() + "' and Part='" + GridAppTable.Rows[i].Cells[5].Text.ToString() + "'and RollNo='N/A' and status='Submitted'", con);
cmd.Parameters.AddWithValue("@RollNo",count);
cmd.Parameters.AddWithValue("@Status", "RollNoGenerated");
cmd.ExecuteNonQuery();
count++;
}
DataTable dtDatas = (DataTable)ViewState["dtDatas"];
dtDatas.Clear();
GridAppTable.DataSource = dtDatas;
GridAppTable.DataBind();
GridView3.DataSource = GetDataSource();
GridView3.DataBind();
GridView2.DataBind();
con.Close();
con.Dispose();
ddlPart.Focus();
}
protected void btnOK_click(object sender, EventArgs e)
{
GridAppTable.DataSource = bindgrid();
GridAppTable.DataBind();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
dtinfo.DateSeparator = "/";
dtinfo.ShortDatePattern = "dd/MM/yyyy";
if (chkDuplicate() == true)
{
con.Close(); con.Open();
string stream = "";
if (lblPart.Text == "PartI" | lblPart.Text == "PartII")
{
stream = "Tech";
}
else
{
stream = "Asso";
}
if (ddlProforma.SelectedValue.ToString() == "ProformaB")
{
updateserialno("BProforma", lblSession.Text.ToString());
}
else if (ddlProforma.SelectedValue.ToString() == "ProformaC")
{
updateserialno("CProforma", lblSession.Text.ToString());
}
SqlCommand cmdnnagar = new SqlCommand("insert into AppRecord(IMID,AppNo,Stream,Course,Part,Name,FName,DOB,DNo,Session,SubDate,Status,FormType,FeeType,Amount,LateFee,Exempted,Enrolment,AdmissionFees,Lavel,CompositeFees,AnnualSubFees,ITIFees,ExamFees,CADFees,underage,DupForm,SID,Exam,ITI,CAD,Project) values(@IMID,@AppNo,@Stream,@Course,@Part,@Name,@FName,@DOB,@DNo,@Session,@SubDate,@Status,@FormType,@FeeType,@Amount,@LateFee,@Exempted,@Enrolment,@AdmissionFees,@Lavel,@CompositeFees,@AnnualSubFees,@ITIFees,@ExamFees,@CADFees,@UnderAge,@DupForm,@SID,@Exam,@ITI,@CAD,@Project)", con);
cmdnnagar.Parameters.AddWithValue("@IMID", lblIMID.Text.ToString());
cmdnnagar.Parameters.AddWithValue("@AppNo", Convert.ToInt32(lblserialNo.Text.ToString()));
cmdnnagar.Parameters.AddWithValue("@Stream", stream);
cmdnnagar.Parameters.AddWithValue("@Course", lblCourse.Text.ToString());
cmdnnagar.Parameters.AddWithValue("@Part", lblPart.Text.ToString());
cmdnnagar.Parameters.AddWithValue("@Name", lblStudentName.Text.ToString());
cmdnnagar.Parameters.AddWithValue("@FName", lblFName.Text.ToString());
cmdnnagar.Parameters.AddWithValue("@DOB", lblDoB.Text.ToString());
cmdnnagar.Parameters.AddWithValue("@DNo", txtDiaryNo.Text.ToString());
cmdnnagar.Parameters.AddWithValue("@Session", lblSession.Text.ToString());
cmdnnagar.Parameters.AddWithValue("@SubDate", Convert.ToDateTime(lblDairyDate.Text, dtinfo));
cmdnnagar.Parameters.AddWithValue("@Status", "NotApproved");
cmdnnagar.Parameters.AddWithValue("@FormType", ddlProforma.SelectedValue.ToString());
cmdnnagar.Parameters.AddWithValue("@FeeType", ddlProforma.SelectedValue.ToString());
cmdnnagar.Parameters.AddWithValue("@Amount", lblSubmitFees.Text.ToString());
cmdnnagar.Parameters.AddWithValue("@LateFee", 0);
cmdnnagar.Parameters.AddWithValue("@Exempted", 0);
cmdnnagar.Parameters.AddWithValue("@Enrolment", txtSID.Text.ToString());
cmdnnagar.Parameters.AddWithValue("@AdmissionFees", 0);
cmdnnagar.Parameters.AddWithValue("@Lavel", lblDupForm.Text.ToString());
cmdnnagar.Parameters.AddWithValue("@CompositeFees", 0);
cmdnnagar.Parameters.AddWithValue("@AnnualSubFees", 0);
cmdnnagar.Parameters.AddWithValue("@ITIFees", 0);
cmdnnagar.Parameters.AddWithValue("@ExamFees", 0);
cmdnnagar.Parameters.AddWithValue("@CADFees", 0);
cmdnnagar.Parameters.AddWithValue("@UnderAge", 0);
cmdnnagar.Parameters.AddWithValue("@DupForm", 0);
cmdnnagar.Parameters.AddWithValue("@SID", txtSID.Text.ToString());
cmdnnagar.Parameters.AddWithValue("@Exam", "");
cmdnnagar.Parameters.AddWithValue("@ITI", "");
cmdnnagar.Parameters.AddWithValue("@CAD", "");
cmdnnagar.Parameters.AddWithValue("@Project", lblProjSerialNo.Text.ToString());
cmdnnagar.ExecuteNonQuery();
string qry = "", qry1 = "";
if (ddlProforma.SelectedValue.ToString() == "ProformaB")
{
qry = "Update Project set ApprovalFees='" + lblSubmitFees.Text.ToString() + "',DiaryB='" + lblserialNo.Text + "/" + lblProjSerialNo.Text.ToString() + "' where SID='" + txtSID.Text.ToString() + "' and EntryStatus='Running'";
qry1 = "update ProjectCount set ProformaBSub=ProformaBSub+1 where DairyNo='" + txtDiaryNo.Text + "'";
lblProformaBFees.Text = lblProjectApproval.Text.ToString();
}
else
{
qry = "Update Project set EvalutionFees='" + lblSubmitFees.Text.ToString() + "',DiaryC='" + lblserialNo.Text + "/" + lblProjSerialNo.Text.ToString() + "' where SID='" + txtSID.Text.ToString() + "' and EntryStatus='Running'";
qry1 = "update ProjectCount set ProformaASub=ProformaASub+1 where DairyNo='" + txtDiaryNo.Text + "'";
lblProformaCFees.Text = lblProjectEvaluation.Text.ToString();
}
cmd = new SqlCommand(qry, con);
cmd.ExecuteNonQuery();
cmd = new SqlCommand(qry1, con);
cmd.ExecuteNonQuery();
SqlDataAdapter ad = new SqlDataAdapter("select Enrolment,Name,FName,DOB,FormType,FeeType,Amount,DNo,SubDate,AppNo from AppRecord where DNo='" + txtDiaryNo.Text.ToString() + "' and (FormType='ProformaB' or FormType='ProformaC') order by AppNo DESC", con);
DataTable dt = new DataTable();
ad.Fill(dt);
GridAppTable.DataSource = dt;
GridAppTable.DataBind();
con.Close(); con.Dispose();
btnSubmit.Enabled = false;
}
else
{
lblException.Text = "Duplicate Record Found.";
lblException.Attributes.Add("class", "error");
}
}
