Esempio n. 1
0
 public int InsertGradeSystem(BOGradeSytem grades)
 {
     DAGradeSystem pDAL = new DAGradeSystem();
     try
     {
         return pDAL.InsertGradeSystem(grades);
     }
     catch
     {
         throw;
     }
     finally
     {
         pDAL = null;
     }
 }
Esempio n. 2
0
        public int InsertGradeSystem(BOGradeSytem grade)
        {
            SqlParameter[] sqlParams = new SqlParameter[12];
            sqlParams[0] = new SqlParameter("@FirstMarks", grade.FirstMarks);
            sqlParams[1] = new SqlParameter("@SecondMarks", grade.SecondMarks);
            sqlParams[2] = new SqlParameter("@ExamType", grade.ExamTypeId);
            sqlParams[3] = new SqlParameter("@Grade", grade.GradeId);
            sqlParams[4] = new SqlParameter("@Marks", grade.Marks);
            sqlParams[5] = new SqlParameter("@Status", grade.Status);
            sqlParams[6] = new SqlParameter("@HostCode", grade.HostCode);
            sqlParams[7] = new SqlParameter("@RecordId", grade.Id);
            sqlParams[8] = new SqlParameter("@CreatedDate", DateTime.Now);
            sqlParams[9] = new SqlParameter("@ModifiedDate", DateTime.Now);
            sqlParams[10] = new SqlParameter("@CreatedBy", grade.UserId);
            sqlParams[11] = new SqlParameter("@ModifiedBy", grade.UserId);

            return cmnDA.ExecuteNonQuery("pr_Gradings_AddOrUpdate", sqlParams);
        }
Esempio n. 3
0
        protected void btn_Click(object sender, EventArgs e)
        {
            try
            {
                var gradeSys = new BOGradeSytem();

                int catid = 0;
                if (ViewState["gradeid"] != null)
                    catid = Convert.ToInt16(ViewState["gradeid"]);

                gradeSys.Id = catid;
                gradeSys.FirstMarks = Convert.ToInt16(txtFirstMark.Text.Trim());
                gradeSys.SecondMarks = Convert.ToInt16(txtSecondMark.Text.Trim());
                gradeSys.HostCode = "DEMO";
                gradeSys.UserId = 1;
                gradeSys.ExamTypeId = Convert.ToInt16(drpExamType.SelectedValue);
                gradeSys.GradeId = Convert.ToInt16(drpGrade.SelectedValue);
                gradeSys.Marks = drpMarks.SelectedItem.Text;
                gradeSys.Status = "A";

                var isInserted = (new BLGradeSystem()).InsertGradeSystem(gradeSys);
                if (isInserted == 1)
                {
                    LoadGradeSystem();
                    GradeUpdatePanel.Update();
                    ResetControls();
                    lblErrorMsg.ForeColor = System.Drawing.Color.Red;
                    lblErrorMsg.Text = "Grade system inserted 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.";
            }
        }
Esempio n. 4
0
        public List<BOGradeSytem> LoadGradeSystems(int userid, string hostCode)
        {
            DAGradeSystem pDAL = new DAGradeSystem();
            try
            {
                var dtCategories = pDAL.LoadGradeSystem(userid, hostCode);
                var grades = new List<BOGradeSytem>();
                BOGradeSytem grade = null;
                foreach (DataRow item in dtCategories.Rows)
                {
                    grade = new BOGradeSytem();

                    int firstMark;
                    int.TryParse(item["FirstMarks"].ToString(), out firstMark);
                    grade.FirstMarks = firstMark;

                    int secondMark;
                    int.TryParse(item["SecondMarks"].ToString(), out secondMark);
                    grade.SecondMarks = secondMark;

                    int examType;
                    int.TryParse(item["ExamTypeId"].ToString(), out examType);
                    grade.ExamTypeId = examType;

                    int gradeid;
                    int.TryParse(item["GradeId"].ToString(), out gradeid);
                    grade.GradeId = gradeid;

                    grade.ExamType = item["ExamType"].ToString();
                    grade.Grade = item["Grade"].ToString();
                    grade.Marks = item["Marks"].ToString();
                    grade.Id = Convert.ToInt32(item["Id"]);

                    grades.Add(grade);
                }

                return grades;
            }
            catch
            {
                throw;
            }
            finally
            {
                pDAL = null;
            }
        }