public static CustomList<UserProfile> GetAllUserProfile(String userCode) { ConnectionManager conManager = new ConnectionManager(ConnectionName.SysMan); CustomList<UserProfile> UserProfileCollection = new CustomList<UserProfile>(); IDataReader reader = null; String sql = "select *from UserProfile Where UserCode='" + userCode + "'"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { UserProfile newUserProfile = new UserProfile(); newUserProfile.SetData(reader); UserProfileCollection.Add(newUserProfile); } return UserProfileCollection; } catch(Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public DataSet LoadMailInfo(Int32 ReportID) { ConnectionManager conManager = new ConnectionManager(ConName); IDataReader reader = null; try { DataSet dsRef = new DataSet(); const String spName = "spGetMailInfo"; conManager.OpenDataReader(out reader, spName, ReportID); dsRef = Util.DataReaderToDataSet(reader); return dsRef; } catch (Exception ex) { throw (ex); } finally { if (conManager != null) { conManager.CloseConnection(); conManager.Dispose(); } if (reader.IsNotNull() && reader.IsClosed.IsFalse()) reader.Close(); } }
public static CustomList<LatestNews> GetAllLatestNews() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<LatestNews> LatestNewsCollection = new CustomList<LatestNews>(); IDataReader reader = null; const String sql = "select *from LatestNews"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { LatestNews newLatestNews = new LatestNews(); newLatestNews.SetData(reader); LatestNewsCollection.Add(newLatestNews); } LatestNewsCollection.InsertSpName = "spInsertLatestNews"; LatestNewsCollection.UpdateSpName = "spUpdateLatestNews"; LatestNewsCollection.DeleteSpName = "spDeleteLatestNews"; return LatestNewsCollection; } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public static CustomList<GroupRule> GetAllGroupSecurityRule(string groupCode) { ConnectionManager conManager = new ConnectionManager(ConnectionName.SysMan); CustomList<GroupRule> GroupSecurityRuleCollection = new CustomList<GroupRule>(); String sql = "Select *from GroupRule where GroupCode='" + groupCode + "'"; IDataReader reader = null; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { GroupRule newGroupSecurityRule = new GroupRule(); newGroupSecurityRule.SetData(reader); GroupSecurityRuleCollection.Add(newGroupSecurityRule); } reader.Close(); GroupSecurityRuleCollection.InsertSpName = "spInsertGroupRule"; GroupSecurityRuleCollection.SelectSpName = "spDeleteGroupRule"; return GroupSecurityRuleCollection; } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void DeleteSecurityRule(ref CustomList<RuleDetails> objSecurityRuleDetailList, ref CustomList<SecurityRule> securityRuleList) { ConnectionManager conManager = new ConnectionManager(ConnectionName.SysMan); Boolean blnTranStarted = false; try { ReSetSPNameForDelete(securityRuleList, objSecurityRuleDetailList); conManager.BeginTransaction(); blnTranStarted = true; conManager.SaveDataCollectionThroughCollection(blnTranStarted, objSecurityRuleDetailList, securityRuleList); objSecurityRuleDetailList.AcceptChanges(); securityRuleList.AcceptChanges(); conManager.CommitTransaction(); blnTranStarted = false; conManager.Dispose(); } catch (Exception ex) { conManager.RollBack(); throw (ex); } finally { if (conManager.IsNotNull()) { conManager.Dispose(); } } }
public static CustomList<Configuration> GetAllConfiguration() { ConnectionManager conManager = new ConnectionManager(ConnectionName.SysMan); CustomList<Configuration> ConfigurationCollection = new CustomList<Configuration>(); const String sql = "Select *from tblConfiguration"; IDataReader reader = null; ; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { Configuration newConfiguration = new Configuration(); newConfiguration.SetData(reader); ConfigurationCollection.Add(newConfiguration); } reader.Close(); ConfigurationCollection.SelectSpName = "spSelectConfiguration"; ConfigurationCollection.InsertSpName = "spInsertConfiguration"; ConfigurationCollection.UpdateSpName = "spUpdateConfiguration"; ConfigurationCollection.SelectSpName = "spDeleteConfiguration"; return ConfigurationCollection; } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public static CustomList<ParameterFilterValue> GetReportValue(string parent) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<ParameterFilterValue> ParameterFilterValueCollection = new CustomList<ParameterFilterValue>(); IDataReader reader = null; String sql = "select OrgKey As ActualValues, OrgName As DisplayMember, OrgName As [Values] from Gen_Org Where OrgParentKey in(" + parent + ")";//'" + userCode + "'"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { ParameterFilterValue newParameterFilterValue = new ParameterFilterValue(); newParameterFilterValue.SetData(reader); ParameterFilterValueCollection.Add(newParameterFilterValue); } return ParameterFilterValueCollection; } catch (Exception ex) { throw (ex); } finally { if (conManager != null) { conManager.CloseConnection(); conManager.Dispose(); } if (reader != null && !reader.IsClosed) reader.Close(); } }
public void SaveMailSetup(CustomList<MailSetup> MailSetupList) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); Boolean blnTranStarted = false; try { conManager.BeginTransaction(); blnTranStarted = true; ReSetSPName(ref MailSetupList); conManager.SaveDataCollectionThroughCollection(blnTranStarted, MailSetupList); MailSetupList.AcceptChanges(); conManager.CommitTransaction(); blnTranStarted = false; conManager.Dispose(); } catch (Exception Ex) { conManager.RollBack(); throw Ex; } finally { if (conManager.IsNotNull()) { conManager.Dispose(); } } }
public static CustomList<ItemSubGroup> GetAllItemSubGroup() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<ItemSubGroup> ItemSubGroupCollection = new CustomList<ItemSubGroup>(); IDataReader reader = null; const String sql = "select S.ItemGroupID, S.ItemSubGroupID, S.SubGroupName from ItemGroup I inner join ItemSubGroup S on S.ItemGroupID=I.ItemGroupID order by I.GroupName desc"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { ItemSubGroup newItemSubGroup = new ItemSubGroup(); newItemSubGroup.SetData(reader); ItemSubGroupCollection.Add(newItemSubGroup); } ItemSubGroupCollection.InsertSpName = "spInsertItemSubGroup"; ItemSubGroupCollection.UpdateSpName = "spUpdateItemSubGroup"; ItemSubGroupCollection.DeleteSpName = "spDeleteItemSubGroup"; return ItemSubGroupCollection; } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public static CustomList<Signature> GetSignatureForUniqueCode(String sql) { ConnectionManager conManager = new ConnectionManager(ConnectionName.SysMan); CustomList<Signature> signatureCollection = new CustomList<Signature>(); IDataReader reader = null; try { conManager.OpenDataReader(sql, out reader); if (reader.NextResult()) { while (reader.Read()) { Signature newSignature = new Signature(); newSignature.SetData(reader); signatureCollection.Add(newSignature); } } return signatureCollection; } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void SaveBankAccount(ref CustomList<CmnBankAccount> BankAccountList) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); Boolean blnTranStarted = false; try { conManager.BeginTransaction(); ReSetSPName(BankAccountList); Int32 accountID = BankAccountList[0].AccountID; blnTranStarted = true; if (BankAccountList[0].IsAdded) accountID = Convert.ToInt32(conManager.InsertData(blnTranStarted, BankAccountList)); else conManager.SaveDataCollectionThroughCollection(blnTranStarted, BankAccountList); BankAccountList.AcceptChanges(); conManager.CommitTransaction(); blnTranStarted = false; } catch (Exception Ex) { conManager.RollBack(); throw Ex; } finally { if (conManager.IsNotNull()) { conManager.Dispose(); } } }
public static CustomList<UserGroupList> GetAllUserGroupWithUserCode(string userCode) { ConnectionManager conManager = new ConnectionManager(ConnectionName.SysMan); CustomList<UserGroupList> UserGroupListCollection = new CustomList<UserGroupList>(); String sql = "Exec spUserGroupList'" + userCode + "'"; IDataReader reader = null; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { UserGroupList newUserGroup = new UserGroupList(); newUserGroup.SetData(reader); UserGroupListCollection.Add(newUserGroup); } reader.Close(); return UserGroupListCollection; } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void SaveFiscalYear(ref CustomList<Gen_FY> Gen_FYList) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); Boolean blnTranStarted = false; try { conManager.BeginTransaction(); ReSetSPName(Gen_FYList); blnTranStarted = true; conManager.SaveDataCollectionThroughCollection(blnTranStarted, Gen_FYList); //object scope_Identity = conManager.InsertData(blnTranStarted, BankKist); Gen_FYList.AcceptChanges(); conManager.CommitTransaction(); blnTranStarted = false; conManager.Dispose(); } catch (Exception Ex) { conManager.RollBack(); throw Ex; } finally { if (conManager.IsNotNull()) { conManager.Dispose(); } } }
public void DeleteVoucher(ref CustomList<Acc_VoucherDet> VoucherDetList, ref CustomList<Acc_Voucher> VoucherList) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); Boolean blnTranStarted = false; try { ReSetSPName(ref VoucherList, ref VoucherDetList); conManager.BeginTransaction(); blnTranStarted = true; conManager.SaveDataCollectionThroughCollection(blnTranStarted, VoucherDetList, VoucherList); conManager.CommitTransaction(); VoucherDetList.AcceptChanges(); VoucherList.AcceptChanges(); } catch (Exception ex) { conManager.RollBack(); throw (ex); } finally { if (conManager.IsNotNull()) { blnTranStarted = false; conManager.Dispose(); } } }
public static Int32 GetUniqueCodeWithoutSignature(ref ConnectionManager objCon, Boolean requiredTransaction, String strTableName, String strFieldName, String strPrefix) { String sql = ""; Int32 strMaxId = 0; try { sql = "Exec spGetIDWithoutSignature '" + strTableName + "','" + strFieldName + "','" + strPrefix + "'"; IDataReader reader; objCon.OpenDataReader(sql, out reader, CommandBehavior.Default, requiredTransaction); while (reader.Read()) { strMaxId = Convert.ToInt32(reader["MaxId"]); } reader.Close(); return strMaxId; } catch (Exception ex) { throw (ex); } }
public void SaveBankReconciliation(ref CustomList<Acc_Voucher> VoucherList) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); Boolean blnTranStarted = false; try { conManager.BeginTransaction(); VoucherList.UpdateSpName = "spUpdateAcc_VoucherBankReconciliation"; blnTranStarted = true; conManager.SaveDataCollectionThroughCollection(blnTranStarted, VoucherList); VoucherList.AcceptChanges(); conManager.CommitTransaction(); blnTranStarted = false; } catch (Exception Ex) { conManager.RollBack(); throw Ex; } finally { if (conManager.IsNotNull()) { conManager.Dispose(); } } }
public void DeleteHKEntry(ref CustomList<HouseKeepingValue> HKList, ref CustomList<HousekeepingHierarchy> lstChild) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); Boolean blnTranStarted = false; try { conManager.BeginTransaction(); ReSetSPName(HKList, lstChild); blnTranStarted = true; conManager.SaveDataCollectionThroughCollection(blnTranStarted, lstChild, HKList); lstChild.AcceptChanges(); HKList.AcceptChanges(); conManager.CommitTransaction(); blnTranStarted = false; conManager.Dispose(); } catch (Exception Ex) { conManager.RollBack(); throw Ex; } finally { if (conManager.IsNotNull()) { conManager.Dispose(); } } }
public void SaveUnitSetup(ref CustomList<ItemSubGroup> lstItemSubGroup) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); Boolean blnTranStarted = false; try { conManager.BeginTransaction(); ReSetSPName(lstItemSubGroup); blnTranStarted = true; conManager.SaveDataCollectionThroughCollection(blnTranStarted, lstItemSubGroup); lstItemSubGroup.AcceptChanges(); conManager.CommitTransaction(); blnTranStarted = false; conManager.Dispose(); } catch (Exception Ex) { conManager.RollBack(); throw Ex; } finally { if (conManager.IsNotNull()) { conManager.Dispose(); } } }
public static CustomList<EmployeeHKInfo> GetAllEmployeeHKInfo(Int64 empKey) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<EmployeeHKInfo> EmployeeHKInfoCollection = new CustomList<EmployeeHKInfo>(); IDataReader reader = null; String sql = "select *from EmployeeHKInfo where EmpKey=" + empKey; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { EmployeeHKInfo newEmployeeHKInfo = new EmployeeHKInfo(); newEmployeeHKInfo.SetData(reader); EmployeeHKInfoCollection.Add(newEmployeeHKInfo); } EmployeeHKInfoCollection.InsertSpName = "spInsertEmployeeHKInfo"; EmployeeHKInfoCollection.UpdateSpName = "spUpdateEmployeeHKInfo"; EmployeeHKInfoCollection.DeleteSpName = "spDeleteEmployeeHKInfo"; return EmployeeHKInfoCollection; } catch(Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public static CustomList<UnitSetup> GetAllUnitSetup() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<UnitSetup> UnitSetupCollection = new CustomList<UnitSetup>(); IDataReader reader = null; const String sql = "select *from UnitSetup"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { UnitSetup newUnitSetup = new UnitSetup(); newUnitSetup.SetData(reader); UnitSetupCollection.Add(newUnitSetup); } UnitSetupCollection.InsertSpName = "spInsertUnitSetup"; UnitSetupCollection.UpdateSpName = "spUpdateUnitSetup"; UnitSetupCollection.DeleteSpName = "spDeleteUnitSetup"; return UnitSetupCollection; } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void SaveCmnDocListTableMapping(ref CustomList<CmnDocListTableMapping> CmnDocListTableMappingList) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); Boolean blnTranStarted = false; try { conManager.BeginTransaction(); ReSetSPName(CmnDocListTableMappingList); Int64 TransactionTypeKey = CmnDocListTableMappingList[0].DocListTableMappingID; blnTranStarted = true; if (CmnDocListTableMappingList[0].IsAdded) TransactionTypeKey = Convert.ToInt64(conManager.InsertData(blnTranStarted, CmnDocListTableMappingList)); else conManager.SaveDataCollectionThroughCollection(blnTranStarted, CmnDocListTableMappingList); CmnDocListTableMappingList.AcceptChanges(); conManager.CommitTransaction(); blnTranStarted = false; } catch (Exception Ex) { conManager.RollBack(); throw Ex; } finally { if (conManager.IsNotNull()) { conManager.Dispose(); } } }
public void SaveReportPermission(ref CustomList<ReportPermission> rPList) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); Boolean blnTranStarted = false; try { conManager.BeginTransaction(); ReSetSPName(rPList); blnTranStarted = true; conManager.SaveDataCollectionThroughCollection(blnTranStarted, rPList); rPList.AcceptChanges(); conManager.CommitTransaction(); blnTranStarted = false; conManager.Dispose(); } catch (Exception Ex) { throw Ex; } finally { if (conManager.IsNotNull()) { conManager.Dispose(); } } }
public void SaveUserProfile(ref CustomList<UserProfile> UserProfileList) { ConnectionManager conManager = new ConnectionManager(ConnectionName.SysMan); Boolean blnTranStarted = false; try { conManager.BeginTransaction(); ReSetSPName(UserProfileList); blnTranStarted = true; conManager.SaveDataCollectionThroughCollection(blnTranStarted, UserProfileList); UserProfileList.AcceptChanges(); conManager.CommitTransaction(); blnTranStarted = false; conManager.Dispose(); } catch (Exception Ex) { conManager.RollBack(); throw Ex; } finally { if (conManager.IsNotNull()) { conManager.Dispose(); } } }
public void DeleteGroup(ref CustomList<UserGroup> userGroupList, ref CustomList<GroupRule> groupSecurityRuleList, ref CustomList<Group> groupList) { ConnectionManager conManager = new ConnectionManager(ConnectionName.SysMan); Boolean blnTranStarted = false; try { ReSetDeleteSPName(groupList, groupSecurityRuleList, userGroupList); conManager.BeginTransaction(); blnTranStarted = true; conManager.SaveDataCollectionThroughCollection(blnTranStarted, userGroupList, groupSecurityRuleList, groupList); userGroupList.AcceptChanges(); groupSecurityRuleList.AcceptChanges(); groupList.AcceptChanges(); conManager.CommitTransaction(); blnTranStarted = false; conManager.Dispose(); } catch (Exception ex) { conManager.RollBack(); throw (ex); } finally { if (conManager.IsNotNull()) { conManager.Dispose(); } } }
public static CustomList<ContactTypeChild> GetAllContactTypeChild() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<ContactTypeChild> ContactTypeChildCollection = new CustomList<ContactTypeChild>(); IDataReader reader = null; const String sql = "select *from ContactTypeChild"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { ContactTypeChild newContactTypeChild = new ContactTypeChild(); newContactTypeChild.SetData(reader); ContactTypeChildCollection.Add(newContactTypeChild); } ContactTypeChildCollection.InsertSpName = "spInsertContactTypeChild"; ContactTypeChildCollection.UpdateSpName = "spUpdateContactTypeChild"; ContactTypeChildCollection.DeleteSpName = "spDeleteContactTypeChild"; return ContactTypeChildCollection; } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void DeleteTempData(ref CustomList<GroupRule> lstGroupSecurityRule) { ConnectionManager conManager = new ConnectionManager(ConnectionName.SysMan); Boolean blnTranStarted = false; try { ReSetTempTransactionDeleteSPName(ref lstGroupSecurityRule); conManager.BeginTransaction(); blnTranStarted = true; conManager.SaveDataCollectionThroughCollection(blnTranStarted, lstGroupSecurityRule); lstGroupSecurityRule.AcceptChanges(); conManager.CommitTransaction(); blnTranStarted = false; conManager.Dispose(); } catch (Exception ex) { conManager.RollBack(); throw (ex); } finally { if (conManager.IsNotNull()) { conManager.Dispose(); } } }
public void deleteWrokFlow(ref CustomList<CmnWorkFlowMaster> lstCmnWorkFlowMaster, ref CustomList<CmnWorkFlowDetail> lstCmnWorkFlowDetail) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); Boolean blnTranStarted = false; try { conManager.BeginTransaction(); lstCmnWorkFlowDetail.DeleteSpName = "spDeleteCmnWorkFlowDetail"; lstCmnWorkFlowMaster.DeleteSpName = "spDeleteCmnWorkFlowMaster"; blnTranStarted = true; conManager.SaveDataCollectionThroughCollection(blnTranStarted, lstCmnWorkFlowDetail, lstCmnWorkFlowMaster); conManager.CommitTransaction(); blnTranStarted = false; } catch (Exception Ex) { conManager.RollBack(); throw Ex; } finally { if (conManager.IsNotNull()) { conManager.Dispose(); } } }
public static CustomList<SegmentValues> GetAllSegmentValues(Int32 segmentNameID) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<SegmentValues> SegmentValuesCollection = new CustomList<SegmentValues>(); IDataReader reader = null; String sql = "select *from SegmentValues Where SegNameID=" + segmentNameID; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { SegmentValues newSegmentValues = new SegmentValues(); newSegmentValues.SetData(reader); SegmentValuesCollection.Add(newSegmentValues); } return SegmentValuesCollection; } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public static CustomList<CmnBankAccountType> GetAllCmnBankAccountType() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<CmnBankAccountType> CmnBankAccountTypeCollection = new CustomList<CmnBankAccountType>(); IDataReader reader = null; const String sql = "select * from CmnBankAccountType"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { CmnBankAccountType newCmnBankAccountType = new CmnBankAccountType(); newCmnBankAccountType.SetData(reader); CmnBankAccountTypeCollection.Add(newCmnBankAccountType); } return CmnBankAccountTypeCollection; } catch(Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public static CustomList<HousekeepingHierarchy> GetAllHousekeepingHierarchy(Int32 hKID) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<HousekeepingHierarchy> HousekeepingHierarchyCollection = new CustomList<HousekeepingHierarchy>(); IDataReader reader = null; String sql = "select *from HousekeepingHierarchy where HKID=" + hKID; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { HousekeepingHierarchy newHousekeepingHierarchy = new HousekeepingHierarchy(); newHousekeepingHierarchy.SetData(reader); HousekeepingHierarchyCollection.Add(newHousekeepingHierarchy); } return HousekeepingHierarchyCollection; } catch(Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }