Пример #1
0
        public List<BOFee> LoadClassFee(int userid, string hostCode)
        {
            DAGradeSystem pDAL = new DAGradeSystem();
            try
            {
                var dtCategories = pDAL.LoadGradeSystem(userid, hostCode);
                var grades = new List<BOFee>();
                BOFee grade = null;
                foreach (DataRow item in dtCategories.Rows)
                {
                    grade = new BOFee();

                    int classId;
                    int.TryParse(item["ClassId"].ToString(), out classId);
                    grade.ClassId  = classId;

                    grade.TermFees = item["TermFees"].ToString();
                    grade.TotalFee = item["TotalFee"].ToString();
                    grade.Id = Convert.ToInt32(item["Id"]);

                    grades.Add(grade);
                }

                return grades;
            }
            catch
            {
                throw;
            }
            finally
            {
                pDAL = null;
            }
        }
Пример #2
0
        protected void btnsubmit_Click(object sender, EventArgs e)
        {
            try
            {
                var classFee = new BOFee();

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

                classFee.Id = catid;
                classFee.HostCode = "DEMO";
                classFee.UserId = 1;
                classFee.ClassId = Convert.ToInt16(drpclass.SelectedValue);

                string termFees = "";
                foreach (Control divCtrl in divterms.Controls)
                {
                    var txtControls = divCtrl.Controls.OfType<TextBox>();
                    if (txtControls == null) continue;

                    foreach (TextBox textBox in divCtrl.Controls.OfType<TextBox>())
                    {
                        termFees += textBox.Text + ",";
                    }
                }

                classFee.Status = "A";

                var isInserted = (new BLGradeSystem()).InsertClassFee(classFee);
                if (isInserted == 1)
                {
                    LoadClassFee();
                    GradeUpdatePanel.Update();
                    ResetControls();
                    lblErrorMsg.ForeColor = System.Drawing.Color.Red;
                    lblErrorMsg.Text = "Class fee 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.";
            }
        }
Пример #3
0
        public int InsertClassFee(BOFee fee)
        {
            SqlParameter[] sqlParams = new SqlParameter[12];
            sqlParams[0] = new SqlParameter("@ClassId", fee.ClassId);
            sqlParams[1] = new SqlParameter("@TermFees", fee.TermFees);
            sqlParams[5] = new SqlParameter("@Status", fee.Status);
            sqlParams[6] = new SqlParameter("@HostCode", fee.HostCode);
            sqlParams[7] = new SqlParameter("@RecordId", fee.Id);
            sqlParams[8] = new SqlParameter("@CreatedDate", DateTime.Now);
            sqlParams[9] = new SqlParameter("@ModifiedDate", DateTime.Now);
            sqlParams[10] = new SqlParameter("@CreatedBy", fee.UserId);
            sqlParams[11] = new SqlParameter("@ModifiedBy", fee.UserId);

            return cmnDA.ExecuteNonQuery("pr_ClassFee_AddOrUpdate", sqlParams);
        }
Пример #4
0
 public int InsertClassFee(BOFee termFee)
 {
     DAGradeSystem pDAL = new DAGradeSystem();
     try
     {
         return pDAL.InsertClassFee(termFee);
     }
     catch
     {
         throw;
     }
     finally
     {
         pDAL = null;
     }
 }