public static STD_CBEExam GetCBEExamByID(int id)
{
STD_CBEExam cBEExam = new STD_CBEExam();
SqlCBEExamProvider sqlCBEExamProvider = new SqlCBEExamProvider();
cBEExam = sqlCBEExamProvider.GetCBEExamByID(id);
return cBEExam;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
STD_CBEExam cBEExam = new STD_CBEExam();
cBEExam.CandidateName = txtCandidateName.Text;
cBEExam.DOB =txtDOB.Text!=""? Convert.ToDateTime(txtDOB.Text):DateTime.Parse("1/1/1753");
cBEExam.Gender = ddlGender.SelectedItem.Text ;
cBEExam.RegiNo = txtRegiNo.Text;
cBEExam.InstituteName = txtInstituteName.Text;
cBEExam.Tel = txtTel.Text;
cBEExam.Mobile = txtMobile.Text;
cBEExam.Email = txtEmail.Text;
cBEExam.FeesDescription = txtFeesDescription.Text;
cBEExam.AddedBy = Profile.card_id;
cBEExam.AddedDate = DateTime.Now;
cBEExam.UpdatedBy = Profile.card_id;
cBEExam.UpdatedDate = DateTime.Now;
cBEExam.RowStatusID = 1;
int resutl = STD_CBEExamManager.InsertCBEExam(cBEExam);
if (resutl != null)
{
List<STD_CBEExamSubject> examSubjects = new List<STD_CBEExamSubject>();
examSubjects = (List<STD_CBEExamSubject>)Session["examSubjects"];
foreach (STD_CBEExamSubject es in examSubjects)
{
STD_CBEExamSubject examSubject = new STD_CBEExamSubject();
examSubject.SubjectTitle = es.SubjectTitle;
examSubject.SubjectCode = es.SubjectCode;
examSubject.TaxOrPaperVariant = es.TaxOrPaperVariant;
examSubject.ExamDate = es.ExamDate;
examSubject.Fees = es.Fees;
examSubject.AddedBy = Profile.card_id;
examSubject.AddedDate = DateTime.Now;
examSubject.UpdatedBy = Profile.card_id;
examSubject.UpdatedDate = DateTime.Now;
examSubject.RowStatusID = 1;
examSubject.CBEExamID = resutl;
string sql = @"
INSERT INTO [STD_CBEExamAcc]
([Head]
,[AccountFor]
,[Amount]
,[AddedDate]
,[AddedBy]
,[IsOpiningOrClosingAcc])
VALUES
('Exam Fees','" + txtCandidateName.Text + (txtStudentCode.Text.Trim() == "" ? "" : "(" + txtStudentCode.Text + ")") + @"'
,"+es.Fees+",GETDATE(),'"+Profile.FirstName+@"',0);
";
CommonManager.SQLExec(sql);
int re = STD_CBEExamSubjectManager.InsertCBEExamSubject(examSubject);
}
}
Session.Remove("examSubjects");
Response.Redirect("MoneyReceipt.aspx?examID="+resutl);
}
catch (Exception ex)
{
}
}
private void showCBEExamData()
{
STD_CBEExam cBEExam = new STD_CBEExam();
cBEExam = STD_CBEExamManager.GetCBEExamByID(Int32.Parse(Request.QueryString["cBEExamID"]));
txtCandidateName.Text = cBEExam.CandidateName;
txtDOB.Text = cBEExam.DOB.ToShortDateString();
ddlGender.SelectedItem.Text = cBEExam.Gender;
txtRegiNo.Text = cBEExam.RegiNo;
txtInstituteName.Text = cBEExam.InstituteName;
txtTel.Text = cBEExam.Tel;
txtMobile.Text = cBEExam.Mobile;
txtEmail.Text = cBEExam.Email;
txtFeesDescription.Text = cBEExam.FeesDescription;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
STD_CBEExam cBEExam = new STD_CBEExam();
cBEExam = STD_CBEExamManager.GetCBEExamByID(Int32.Parse(Request.QueryString["cBEExamID"]));
STD_CBEExam tempCBEExam = new STD_CBEExam();
tempCBEExam.CBEExamID = cBEExam.CBEExamID;
tempCBEExam.DOB =txtDOB.Text!=""? Convert.ToDateTime(txtDOB.Text):DateTime.Parse("1/1/1753");
tempCBEExam.Gender = ddlGender.SelectedItem.Text;
tempCBEExam.RegiNo = txtRegiNo.Text;
tempCBEExam.InstituteName = txtInstituteName.Text;
tempCBEExam.Tel = txtTel.Text;
tempCBEExam.Mobile = txtMobile.Text;
tempCBEExam.Email = txtEmail.Text;
tempCBEExam.FeesDescription = txtFeesDescription.Text;
tempCBEExam.AddedBy = Profile.card_id;
tempCBEExam.AddedDate = DateTime.Now;
tempCBEExam.UpdatedBy = Profile.card_id;
tempCBEExam.UpdatedDate = DateTime.Now;
tempCBEExam.RowStatusID = 1;
bool result = STD_CBEExamManager.UpdateCBEExam(tempCBEExam);
Response.Redirect("AdminCBEExamDisplay.aspx");
}
catch (Exception ex)
{
}
}
public STD_CBEExam GetCBEExamFromReader(IDataReader reader)
{
try
{
STD_CBEExam cBEExam = new STD_CBEExam
(
(int)reader["CBEExamID"],
reader["CandidateName"].ToString(),
(DateTime)reader["DOB"],
reader["Gender"].ToString(),
reader["RegiNo"].ToString(),
reader["InstituteName"].ToString(),
reader["Tel"].ToString(),
reader["Mobile"].ToString(),
reader["Email"].ToString(),
reader["FeesDescription"].ToString(),
reader["AddedBy"].ToString(),
(DateTime)reader["AddedDate"],
reader["UpdatedBy"].ToString(),
(DateTime)reader["UpdatedDate"],
(int)reader["RowStatusID"]
);
try
{
cBEExam.SubjectTitle = reader["SubjectTitle"].ToString();
cBEExam.Fees = (Decimal)reader["Fees"];
}
catch (Exception ex)
{
}
return cBEExam;
}
catch(Exception ex)
{
return null;
}
}
public bool UpdateCBEExam(STD_CBEExam cBEExam)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateSTD_CBEExam", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@CBEExamID", SqlDbType.Int).Value = cBEExam.CBEExamID;
cmd.Parameters.Add("@CandidateName", SqlDbType.NVarChar).Value = cBEExam.CandidateName;
cmd.Parameters.Add("@DOB", SqlDbType.DateTime).Value = cBEExam.DOB;
cmd.Parameters.Add("@Gender", SqlDbType.NVarChar).Value = cBEExam.Gender;
cmd.Parameters.Add("@RegiNo", SqlDbType.NVarChar).Value = cBEExam.RegiNo;
cmd.Parameters.Add("@InstituteName", SqlDbType.NVarChar).Value = cBEExam.InstituteName;
cmd.Parameters.Add("@Tel", SqlDbType.NVarChar).Value = cBEExam.Tel;
cmd.Parameters.Add("@Mobile", SqlDbType.NVarChar).Value = cBEExam.Mobile;
cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = cBEExam.Email;
cmd.Parameters.Add("@FeesDescription", SqlDbType.NVarChar).Value = cBEExam.FeesDescription;
cmd.Parameters.Add("@AddedBy", SqlDbType.UniqueIdentifier).Value = cBEExam.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = cBEExam.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.UniqueIdentifier).Value = cBEExam.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = cBEExam.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = cBEExam.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public int InsertCBEExam(STD_CBEExam cBEExam)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("InsertSTD_CBEExam", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@CBEExamID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@CandidateName", SqlDbType.NVarChar).Value = cBEExam.CandidateName;
cmd.Parameters.Add("@DOB", SqlDbType.DateTime).Value = cBEExam.DOB;
cmd.Parameters.Add("@Gender", SqlDbType.NVarChar).Value = cBEExam.Gender;
cmd.Parameters.Add("@RegiNo", SqlDbType.NVarChar).Value = cBEExam.RegiNo;
cmd.Parameters.Add("@InstituteName", SqlDbType.NVarChar).Value = cBEExam.InstituteName;
cmd.Parameters.Add("@Tel", SqlDbType.NVarChar).Value = cBEExam.Tel;
cmd.Parameters.Add("@Mobile", SqlDbType.NVarChar).Value = cBEExam.Mobile;
cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = cBEExam.Email;
cmd.Parameters.Add("@FeesDescription", SqlDbType.NVarChar).Value = cBEExam.FeesDescription;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = cBEExam.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = cBEExam.AddedDate.AddHours(double.Parse(ConfigurationManager.AppSettings["ServerTimeDiff"].ToString()));
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = cBEExam.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = cBEExam.UpdatedDate.AddHours(double.Parse(ConfigurationManager.AppSettings["ServerTimeDiff"].ToString()));
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = cBEExam.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@CBEExamID"].Value;
}
}
public static bool UpdateCBEExam(STD_CBEExam cBEExam)
{
SqlCBEExamProvider sqlCBEExamProvider = new SqlCBEExamProvider();
return sqlCBEExamProvider.UpdateCBEExam(cBEExam);
}
public static int InsertCBEExam(STD_CBEExam cBEExam)
{
SqlCBEExamProvider sqlCBEExamProvider = new SqlCBEExamProvider();
return sqlCBEExamProvider.InsertCBEExam(cBEExam);
}
