protected void btnViewDiary_Click(object sender, EventArgs e)
{
con.Close(); con.Open();
cmd = new SqlCommand("select DiaryEntry.IMID,DiaryEntry.Date,IM.Name,ProjectCount.Session from ProjectCount inner join DiaryEntry on ProjectCount.DairyNo=DiaryEntry.DiaryNo inner join IM on DiaryEntry.IMID=IM.ID and ProjectCount.DairyNo='" + txtDiaryNo.Text.ToString() + "' and (ProjectCount.ProformaARcv!=ProjectCount.ProformaASub or ProjectCount.ProformaBRcv!=ProjectCount.ProformaBSub)", con);
SqlDataReader reader;
reader = cmd.ExecuteReader();
if (reader.Read())
{
lblIMID.Text = reader["IMID"].ToString();
lblIMName.Text = reader["Name"].ToString();
lblDairyDate.Text = Convert.ToDateTime(reader["Date"].ToString()).ToString("dd/MM/yyyy");
lblSession.Text = reader["Session"].ToString();
lblException.Attributes.Add("class", "hide");
clear(3);
IMcls = new IMInfo();
lblFeemaster.Text = IMcls.imFeeMaster(lblIMID.Text.ToString());
txtSID.Focus();
}
else
{
lblException.Text = "Diary Not Found.";
lblException.Attributes.Add("class", "error");
clear(1);
}
showcount(lblSession.Text, txtDiaryNo.Text, reader);
reader.Close();
reader.Dispose();
con.Close(); con.Dispose();
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
con.Close(); con.Open();
bool flg = false;
cmd = new SqlCommand("select IMID,SID,StudentName,Course,Part,InstitutionID,Institution,Status,SynopsisStatus,ApprovalFees,EvalutionFees from Project where SID='" + txtSID.Text.ToString() + "' and Session='" + lblSessionHidden.Text.ToString() + "'", con);
SqlDataReader reader;
reader = cmd.ExecuteReader();
if (reader.Read())
{
lblIMID.Text = reader["IMID"].ToString();
lblName.Text = reader["StudentName"].ToString();
lblCourse.Text = reader["Course"].ToString();
lblPart.Text = reader["Part"].ToString();
lblStatus.Text = reader["Status"].ToString();
lblInsID.Text = reader["InstitutionID"].ToString();
lblInsName.Text = reader["Institution"].ToString();
lblApprovalFees.Text = reader["ApprovalFees"].ToString().TrimEnd('0').TrimEnd('.');
lblEvaluationFees.Text = reader["EvalutionFees"].ToString().TrimEnd('0').TrimEnd('.');
lblException.Text = "";
flg = true;
}
else
{
lblException.Text = "Student Membership Not Found.";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "success", "alert('Student Membership Not Found.')", true);
flg = false;
}
reader.Close();
if (flg == true)
{
cmd = new SqlCommand("select * from IMAC where IMID='" + lblIMID.Text + "'", con);
reader = cmd.ExecuteReader();
if (reader.Read())
{
lblToAmount.Text = reader["Total"].ToString().TrimEnd('0').TrimEnd('.');
lblDuesAmount.Text = reader["Credit"].ToString().TrimEnd('0').TrimEnd('.');
lblBooksAmt.Text = reader["IMTotal"].ToString().TrimEnd('0').TrimEnd('.');
lblProspectus.Text = reader["Prospectus"].ToString().TrimEnd('0').TrimEnd('.');
lblProjectAmt.Text = reader["Project"].ToString().TrimEnd('0').TrimEnd('.');
}
reader.Close();
reader.Dispose();
iminfo = new IMInfo();
lblFeeType.Text = iminfo.imFeeMaster(lblIMID.Text.ToString());
}
}
catch (SqlException ex)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "success", "alert('Error!!!, Student Membership Not Found.')", true);
}
finally
{
con.Close();
con.Dispose();
ddlProforma.Focus();
}
}
