protected void Delete_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(sdb, Page.Master); errors.clear(); ArrayList list = new ArrayList(); foreach (RepeaterItem i in Repeater.Items) { CheckBox cb = (CheckBox)i.FindControl("ItemSelect"); if (cb.Checked) { EEmpBenefit o = new EEmpBenefit(); WebFormUtils.GetKeys(sdb, o, cb); list.Add(o); } } if (list.Count > 0) { WebUtils.StartFunction(Session, FUNCTION_CODE, CurID); foreach (BaseObject o in list) { if (sdb.select(dbConn, o)) { sdb.delete(dbConn, o); } } WebUtils.EndFunction(dbConn); } loadData(info, sdb, Repeater); }
public void ImportToDatabase(int UploadEmpID) { DBFilter sessionFilter = new DBFilter(); sessionFilter.add(new Match("SessionID", m_SessionID)); if (UploadEmpID > 0) { sessionFilter.add(new Match("UploadEmpID", UploadEmpID)); } ArrayList uploadEmpBenefitList = tempDB.select(dbConn, sessionFilter); foreach (EUploadEmpBenefit obj in uploadEmpBenefitList) { EEmpBenefit EmpBenefit = new EEmpBenefit(); if (obj.ImportActionStatus != ImportDBObject.ImportActionEnum.INSERT) { EmpBenefit.EmpBenefitID = obj.EmpBenefitID; uploadDB.select(dbConn, EmpBenefit); } obj.ExportToObject(EmpBenefit); if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.INSERT) { EmpBenefit.EmpID = ParseTemp.GetEmpIDFromUploadEmpID(dbConn, obj.UploadEmpID); uploadDB.insert(dbConn, EmpBenefit); } else if (obj.ImportActionStatus == ImportDBObject.ImportActionEnum.UPDATE) { uploadDB.update(dbConn, EmpBenefit); } tempDB.delete(dbConn, obj); } }
protected bool loadObject() { obj = new EEmpBenefit(); bool isNew = WebFormWorkers.loadKeys(db, obj, DecryptedRequest); DBFilter filter = new DBFilter(); filter.add(new Match("EmpID", CurEmpID)); filter.add(WebUtils.AddRankFilter(Session, "EmpID", true)); if (EEmpPersonalInfo.db.count(dbConn, filter) == 0) { if (CurEmpID <= 0) { return(false); } else { HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/AccessDeny.aspx"); } } if (!db.select(dbConn, obj)) { if (CurID <= 0) { return(false); } else { HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/AccessDeny.aspx"); } } if (obj.EmpID != CurEmpID) { if (CurID <= 0) { return(false); } else { HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "~/AccessDeny.aspx"); } } Hashtable values = new Hashtable(); db.populate(obj, values); binding.toControl(values); return(true); }
protected void Save_Click(object sender, EventArgs e) { EEmpBenefit c = new EEmpBenefit(); Hashtable values = new Hashtable(); binding.toValues(values); PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); db.validate(errors, values); if (!errors.isEmpty()) { return; } db.parse(values, c); if (!string.IsNullOrEmpty(EmpBenefitExpiryDate.Value) && c.EmpBenefitEffectiveDate.CompareTo(c.EmpBenefitExpiryDate) > 0) { errors.addError(HROne.Translation.PageErrorMessage.ERROR_INCORRECT_DATE_RANGE); } if (!errors.isEmpty()) { return; } WebUtils.StartFunction(Session, FUNCTION_CODE, c.EmpID); if (CurID < 0) { db.insert(dbConn, c); CurID = c.EmpBenefitID; } else { db.update(dbConn, c); } WebUtils.EndFunction(dbConn); HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "Emp_Benefit_View.aspx?EmpBenefitID=" + CurID + "&EmpID=" + c.EmpID); }
protected void Delete_Click(object sender, EventArgs e) { PageErrors errors = PageErrors.getErrors(db, Page.Master); errors.clear(); EEmpBenefit obj = new EEmpBenefit(); obj.EmpBenefitID = CurID; if (EEmpBenefit.db.select(dbConn, obj)) { WebUtils.StartFunction(Session, FUNCTION_CODE, obj.EmpID); db.delete(dbConn, obj); WebUtils.EndFunction(dbConn); } HROne.Common.WebUtility.RedirectURLwithEncryptedQueryString(Response, Session, "EmpTab_Benefit_View.aspx?EmpID=" + EmpID.Value); }