public void setValuesToControls() { try { using (KungFuEntities2 entities = new KungFuEntities2()) { int iStudentProgressID = int.Parse(hdnPKId.Value); var query = (from p in entities.tblStudentProgresses where p.STU_PROG_ID == iStudentProgressID select p).FirstOrDefault(); ddlRankType.SelectedValue = query.RANK_ID.ToString(); string date = query.STU_PROG_RANK_DATE.ToString(); DateTime dt = DateTime.ParseExact(date, "dd-MM-yyyy hh:mm:ss tt", null); txtRankDate.Text = dt.ToString("MM/dd/yyyy"); if (query.STU_PROG_STATUS == true) { chkIsApprove.Checked = true; } else { chkIsApprove.Checked = false; } var objStudent = entities.tblStudents.Where(s => s.STU_ID == query.STU_ID).OrderByDescending(s => s.STU_NUM).FirstOrDefault(); txtStudentNumber.Text = objStudent.STU_NUM; } } catch (Exception ex) { throw ex; } }
public void fillRankTypeddl() { try { using (KungFuEntities2 entities = new KungFuEntities2()) { var category = (from c in entities.tblRanks where c.RANK_STATUS == true select new { c.RANK_ID, c.RANK_BELT_COLOR }).ToList(); ddlRankType.DataValueField = "RANK_ID"; ddlRankType.DataTextField = "RANK_BELT_COLOR"; ddlRankType.DataSource = category; ddlRankType.DataBind(); ddlRankType.Items.Insert(0, new ListItem("--Select Belt Type--")); } } catch (Exception ex) { } }
public void AssignRankStudent() { try { using (KungFuEntities2 entities = new KungFuEntities2()) { var studentID = (from obj in entities.tblStudents where obj.STU_NUM == txtStudentNumber.Text select obj.STU_ID).FirstOrDefault(); var rankID = int.Parse(ddlRankType.SelectedValue); int ihdnPKID = int.Parse(hdnPKId.Value); Int32 studentprogressID = 0; if (ihdnPKID == 0) { studentprogressID = (from obj in entities.tblStudentProgresses where obj.RANK_ID == rankID && obj.STU_ID == studentID select obj.STU_PROG_ID).FirstOrDefault(); } else { studentprogressID = (from obj in entities.tblStudentProgresses where obj.RANK_ID == rankID && obj.STU_ID == studentID && obj.STU_PROG_ID != ihdnPKID select obj.STU_PROG_ID).FirstOrDefault(); } if (studentID != 0 && studentprogressID == 0) { var objStudentProgress = entities.tblStudentProgresses.Where(s => s.STU_PROG_ID == ihdnPKID).OrderByDescending(s => s.STU_PROG_ID).FirstOrDefault(); if (objStudentProgress == null) { objStudentProgress = new tblStudentProgress(); } objStudentProgress.RANK_ID = Convert.ToInt32(ddlRankType.SelectedValue); objStudentProgress.STU_ID = Convert.ToInt32(studentID); objStudentProgress.STU_PROG_CREATED_BY = entities.tblInstructors.AsEnumerable().FirstOrDefault().INSTRUCTOR_ID; objStudentProgress.STU_PROG_CREATED_DATE = DateTime.Now; objStudentProgress.STU_PROG_RANK_DATE = DateTime.ParseExact(txtRankDate.Text, "MM/dd/yyyy", null); objStudentProgress.STU_PROG_STATUS = chkIsApprove.Checked; if (objStudentProgress.STU_PROG_ID == 0) { entities.tblStudentProgresses.Add(objStudentProgress); } else { objStudentProgress.STU_PROG_MODIFY_BY = entities.tblInstructors.Select(x => x.INSTRUCTOR_ID).FirstOrDefault(); objStudentProgress.STU_PROG_MODIFIED_DATE = DateTime.Now; entities.Entry(objStudentProgress).State = System.Data.Entity.EntityState.Modified; } entities.SaveChanges(); objStudentProgress = null; if (hdnPKId.Value != "0") { Response.Redirect("AssignRankList.aspx"); } ResetControls(); divMessage.Visible = true; divErrorMsg.Visible = false; } else { if (studentID == 0) { divErrorMsg.InnerHtml = ""; divErrorMsg.InnerText = "Student does not exist with this number."; } else { divErrorMsg.InnerHtml = ""; divErrorMsg.InnerText = "This belt is already assigned to this student."; } divErrorMsg.Visible = true; divMessage.Visible = false; return; } } } catch (Exception ex) { } }