private void GetData() { try { List <PeriodPerjawatanGridHelper> data = new PeriodPerjawatanDAL().GetPeriodPerjawatans() .Select(x => new PeriodPerjawatanGridHelper() { PeriodPerjawatanID = x.PeriodPerjawatanID, FieldPerjawatanID = x.FieldPerjawatanID, FieldPerjawatan = x.FieldPerjawatan.FieldPerjawatanDesc, PerjawatanYear = x.PerjawatanYear, Status = ((x.Status == "A") ? "A" : "D") }).OrderBy(x => x.PerjawatanYear).ToList(); Session["PeriodPerjawatanData"] = data; BindGrid(); LoadDropDown(); } catch (Exception ex) { ((SiteMaster)this.Master).ShowMessage("Error", "An error occurred", ex, true); } }
protected void btnSave_Click(object sender, EventArgs e) { try { int FieldID = new FieldPerjawatanDAL().GetFieldPerjawatans().Where(x => x.FieldPerjawatanDesc.Contains("Bil Perjawatan") && x.Status == "A").Select(y => y.FieldPerjawatanID).FirstOrDefault(); if ((Helper.PageMode)Session["PeriodPerjawatanPageMode"] == Helper.PageMode.New) { if (new PeriodPerjawatanDAL().GetPeriodPerjawatans().Where(x => x.FieldPerjawatanID == FieldID && x.PerjawatanYear == Convert.ToInt32(ddlYear.SelectedValue)).Count() > 0) { ((SiteMaster)this.Master).ShowMessage("Failure", "Period Perjawatan already exists"); return; } PeriodPerjawatan objPeriodPerjawatan = new PeriodPerjawatan(); objPeriodPerjawatan.FieldPerjawatanID = FieldID; objPeriodPerjawatan.PerjawatanYear = Convert.ToInt32(ddlYear.SelectedValue); objPeriodPerjawatan.Status = new Helper().GetItemStatusEnumValueByName(ddlStatus.SelectedValue); objPeriodPerjawatan.CreatedBy = LoggedInUser.UserID; objPeriodPerjawatan.CreatedTimeStamp = DateTime.Now; objPeriodPerjawatan.ModifiedBy = LoggedInUser.UserID; objPeriodPerjawatan.ModifiedTimeStamp = DateTime.Now; if (new PeriodPerjawatanDAL().InsertPeriodPerjawatan(objPeriodPerjawatan)) { ((SiteMaster)this.Master).ShowMessage("Success", "Period Perjawatan saved successfully"); } else { ((SiteMaster)this.Master).ShowMessage("Failure", "An error occurred while saving Period Perjawatan"); } } else if ((Helper.PageMode)Session["PeriodPerjawatanPageMode"] == Helper.PageMode.Edit) { PeriodPerjawatan objPeriodPerjawatan = (PeriodPerjawatan)Session["SelectedPeriodPerjawatan"]; PeriodPerjawatan pp = new PeriodPerjawatanDAL().GetPeriodPerjawatans().Where(x => x.FieldPerjawatanID == FieldID && x.PerjawatanYear == Convert.ToInt32(ddlYear.SelectedValue)).FirstOrDefault(); if (pp != null) { if (pp.PeriodPerjawatanID != objPeriodPerjawatan.PeriodPerjawatanID) { ((SiteMaster)this.Master).ShowMessage("Failure", "Period Perjawatan already exists"); return; } } objPeriodPerjawatan.FieldPerjawatanID = FieldID; objPeriodPerjawatan.PerjawatanYear = Convert.ToInt32(ddlYear.SelectedValue); objPeriodPerjawatan.Status = new Helper().GetItemStatusEnumValueByName(ddlStatus.SelectedValue); objPeriodPerjawatan.ModifiedBy = LoggedInUser.UserID; objPeriodPerjawatan.ModifiedTimeStamp = DateTime.Now; if (new PeriodPerjawatanDAL().UpdatePeriodPerjawatan(objPeriodPerjawatan)) { ((SiteMaster)this.Master).ShowMessage("Success", "Period Perjawatan updated successfully"); } else { ((SiteMaster)this.Master).ShowMessage("Failure", "An error occurred while updating Period Perjawatan"); } } GetData(); ClearPageData(); EditForm.Visible = false; } catch (Exception ex) { ((SiteMaster)this.Master).ShowMessage("Error", "An error occurred", ex, true); } }