private void LoadDropDown() { try { ddlStatus.DataSource = Enum.GetValues(typeof(Helper.ItemStatus)); ddlStatus.DataBind(); for (int i = DateTime.Now.Year; i <= DateTime.Now.Year + 10; i++) { ddlYear.Items.Add(new ListItem(i.ToString(), i.ToString())); } List <FieldPerjawatan> obj = new FieldPerjawatanDAL().GetFieldPerjawatans().Where(x => x.FieldPerjawatanDesc.Contains("Bil Perjawatan") && x.Status == "A").ToList(); foreach (var item in obj) { tbFieldPerjawatan.Text = string.Format("{0}", item.FieldPerjawatanDesc); } } 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); } }