public List<BOTermPlan> LoadTermPlans(int userid, string hostCode)
{
DATermPlan pDAL = new DATermPlan();
try
{
var dtCategories = pDAL.LoadTermPlans(userid, hostCode);
var grades = new List<BOTermPlan>();
BOTermPlan grade = null;
foreach (DataRow item in dtCategories.Rows)
{
grade = new BOTermPlan();
int plan;
int.TryParse(item["Plan"].ToString(), out plan);
grade.Plan = plan;
int from;
int.TryParse(item["From"].ToString(), out from);
grade.From = from;
int To;
int.TryParse(item["To"].ToString(), out To);
grade.To = To;
int pclass;
int.TryParse(item["Class"].ToString(), out pclass);
grade.Class = pclass;
int month;
int.TryParse(item["Month"].ToString(), out month);
grade.Month = month;
int subject;
int.TryParse(item["Subject"].ToString(), out subject);
grade.Subject = subject;
grade.Syllabus = item["Syllabus"].ToString();
grade.Id = Convert.ToInt32(item["Id"]);
grades.Add(grade);
}
return grades;
}
catch
{
throw;
}
finally
{
pDAL = null;
}
}
public int InsertTermPlan(BOTermPlan plans)
{
DATermPlan pDAL = new DATermPlan();
try
{
return pDAL.InsertTermPlan(plans);
}
catch
{
throw;
}
finally
{
pDAL = null;
}
}
protected void btn_Click(object sender, EventArgs e)
{
try
{
var plans = new BOTermPlan();
int planId = 0;
if (ViewState["planId"] != null)
planId = Convert.ToInt16(ViewState["planId"]);
plans.Id = planId;
plans.Plan = Convert.ToInt16(drpTerm.SelectedValue);
plans.From = Convert.ToInt16(drpFrom.SelectedValue);
plans.To = Convert.ToInt16(drpTo.SelectedValue);
plans.Class = Convert.ToInt16(drpClass.SelectedValue);
plans.Month = Convert.ToInt16(drpMonth.SelectedValue);
plans.Subject = Convert.ToInt16(drpSubject.SelectedValue);
plans.Syllabus = txtSyllabus.Text;
plans.HostCode = "DEMO";
plans.UserId = 1;
plans.Status = "A";
var isInserted = (new BLTermPlan()).InsertTermPlan(plans);
if (isInserted == 1)
{
LoadTermPlans();
GradeUpdatePanel.Update();
ResetControls();
lblErrorMsg.ForeColor = System.Drawing.Color.Green;
lblErrorMsg.Text = "Term plan saved successfully.";
}
else
{
lblErrorMsg.ForeColor = System.Drawing.Color.Red;
lblErrorMsg.Text = "Process failed. Please try again.";
}
}
catch (Exception ex)
{
lblErrorMsg.ForeColor = System.Drawing.Color.Red;
lblErrorMsg.Text = "Unable to save data.";
}
}
public int InsertTermPlan(BOTermPlan plans)
{
SqlParameter[] sqlParams = new SqlParameter[14];
sqlParams[0] = new SqlParameter("@TermTypeId", plans.Plan);
sqlParams[1] = new SqlParameter("@TermFromId", plans.From);
sqlParams[2] = new SqlParameter("@TermToId", plans.To);
sqlParams[3] = new SqlParameter("@ClassId", plans.Class);
sqlParams[4] = new SqlParameter("@MonthId", plans.Month);
sqlParams[5] = new SqlParameter("@SubjectId", plans.Subject);
sqlParams[6] = new SqlParameter("@Syllabus", plans.Syllabus);
sqlParams[7] = new SqlParameter("@Status", plans.Status);
sqlParams[8] = new SqlParameter("@HostCode", plans.HostCode);
sqlParams[9] = new SqlParameter("@RecordId", plans.Id);
sqlParams[10] = new SqlParameter("@CreatedDate", DateTime.Now);
sqlParams[11] = new SqlParameter("@ModifiedDate", DateTime.Now);
sqlParams[12] = new SqlParameter("@CreatedBy", plans.UserId);
sqlParams[13] = new SqlParameter("@ModifiedBy", plans.UserId);
return cmnDA.ExecuteNonQuery("pr_TermPlans_AddOrUpdate", sqlParams);
}
