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); }