protected void btnSave_Click(object sender, EventArgs e) { try { CustomList <HouseKeepingValue> lstHKEntry = HouseKeepingList; if (lstHKEntry.Count == 0) { HouseKeepingValue newHouseKeepingEntry = new HouseKeepingValue(); lstHKEntry.Add(newHouseKeepingEntry); } CustomList <HouseKeepingValue> lstParent = ParentList; CustomList <HousekeepingHierarchy> lstChild = ChildList; CustomList <HousekeepingHierarchy> savedList = new CustomList <HousekeepingHierarchy>(); foreach (HouseKeepingValue hKV in lstParent) { if (hKV.IsSaved) { HousekeepingHierarchy childObj = ChildList.Find(f => f.ParentID == hKV.HKID); if (childObj.IsNotNull()) { savedList.Add(childObj); } else { HousekeepingHierarchy obj = new HousekeepingHierarchy(); obj.ParentID = hKV.HKID; savedList.Add(obj); } } else { HousekeepingHierarchy childObj = ChildList.Find(f => f.ParentID == hKV.HKID); if (childObj.IsNotNull()) { childObj.Delete(); savedList.Add(childObj); } } } SetDataFromControls(ref lstHKEntry); if (!CheckUserAuthentication(lstHKEntry)) { return; } manager.SaveHKEntry(ref lstHKEntry, ref savedList); this.SuccessMessage = (StaticInfo.SavedSuccessfullyMsg); } catch (SqlException ex) { this.ErrorMessage = (ExceptionHelper.getSqlExceptionMessage(ex)); } catch (Exception ex) { this.ErrorMessage = (ExceptionHelper.getExceptionMessage(ex)); } }
public void DeleteHKEntry(ref CustomList <HouseKeepingValue> HKList, ref CustomList <HouseKeepingValue> lstParent, ref CustomList <HousekeepingHierarchy> lstChild) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); Boolean blnTranStarted = false; try { conManager.BeginTransaction(); ReSetSPName(HKList); blnTranStarted = true; foreach (HouseKeepingValue h in HKList) { h.Delete(); } CustomList <HousekeepingHierarchy> hKHList = new CustomList <HousekeepingHierarchy>(); CustomList <HousekeepingHierarchy> deletedHKHList = new CustomList <HousekeepingHierarchy>(); foreach (HouseKeepingValue hKV in lstParent) { HousekeepingHierarchy deletedObj = lstChild.Find(f => f.ParentID == hKV.HKID); if (deletedObj.IsNotNull()) { deletedHKHList.Add(deletedObj); } } conManager.SaveDataCollectionThroughCollection(blnTranStarted, deletedHKHList, HKList); deletedHKHList.AcceptChanges(); hKHList.AcceptChanges(); HKList.AcceptChanges(); conManager.CommitTransaction(); blnTranStarted = false; conManager.Dispose(); } catch (Exception Ex) { conManager.RollBack(); throw Ex; } finally { if (conManager.IsNotNull()) { conManager.Dispose(); } } }
public CustomList <HousekeepingHierarchy> GetAllHousekeepingHierarchy(Int32 hKID) { return(HousekeepingHierarchy.GetAllHousekeepingHierarchy(hKID)); }
public void SaveHKEntry(ref CustomList <HouseKeepingValue> HKList, ref CustomList <HouseKeepingValue> lstParent, ref CustomList <HousekeepingHierarchy> lstChild) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); Boolean blnTranStarted = false; try { conManager.BeginTransaction(); ReSetSPName(HKList); blnTranStarted = true; Object scope_Identity = null; if (HKList[0].IsAdded) { scope_Identity = conManager.InsertData(blnTranStarted, HKList); } else { conManager.SaveDataCollectionThroughCollection(blnTranStarted, HKList); } CustomList <HousekeepingHierarchy> hKHList = new CustomList <HousekeepingHierarchy>(); CustomList <HousekeepingHierarchy> deletedHKHList = new CustomList <HousekeepingHierarchy>(); foreach (HouseKeepingValue hKV in lstParent) { if (!hKV.IsSaved) { HousekeepingHierarchy deletedObj = lstChild.Find(f => f.ParentID == hKV.HKID); if (deletedObj.IsNotNull()) { deletedHKHList.Add(deletedObj); } } if (hKV.IsSaved) { HousekeepingHierarchy hKH = new HousekeepingHierarchy(); HousekeepingHierarchy deletedHKH = new HousekeepingHierarchy(); if (scope_Identity.IsNull()) { hKH.HKID = HKList[0].HKID; deletedHKH.HKID = HKList[0].HKID; } else { hKH.HKID = Convert.ToInt32(scope_Identity); deletedHKH.HKID = Convert.ToInt32(scope_Identity); HKList[0].HKID = Convert.ToInt32(scope_Identity); } hKH.ParentID = hKV.HKID; deletedHKH.ParentID = hKV.HKID; hKHList.Add(hKH); deletedHKHList.Add(deletedHKH); } } deletedHKHList.ForEach(f => f.Delete()); hKHList.InsertSpName = "spInsertHousekeepingHierarchy"; hKHList.UpdateSpName = "spUpdateHousekeepingHierarchy"; hKHList.DeleteSpName = "spDeleteHousekeepingHierarchy"; deletedHKHList.DeleteSpName = "spDeleteHousekeepingHierarchy"; conManager.SaveDataCollectionThroughCollection(blnTranStarted, deletedHKHList, hKHList); deletedHKHList.AcceptChanges(); hKHList.AcceptChanges(); conManager.CommitTransaction(); blnTranStarted = false; conManager.Dispose(); } catch (Exception Ex) { conManager.RollBack(); throw Ex; } finally { if (conManager.IsNotNull()) { conManager.Dispose(); } } }