public BusinessObjects.Models.Screen selectActiveScreenByBankName(string bankName) { try { string pquery = "SELECT tblScreens.* FROM tblScreens inner join tblBanks on tblBanks.id = tblScreens.bankId where tblBanks.name = @bankName and isActive = 1"; List <SqlParameter> screenParams = new List <SqlParameter>(); screenParams.Add(new SqlParameter("@bankName", bankName)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); DataSet dataSet = dBHelper.executeAdapter(pquery, screenParams); if (dataSet == null) { return(null); } if (dataSet.Tables[0].Rows.Count == 0) { return(new BusinessObjects.Models.Screen()); } DataRow dataRow = dataSet.Tables[0].Rows[0]; BusinessObjects.Models.Screen screen = new BusinessObjects.Models.Screen(Convert.ToInt32(dataRow["id"]) , Convert.ToString(dataRow["name"]), Convert.ToBoolean(dataRow["isActive"]), Convert.ToInt32(dataRow["bankId"])); return(screen); } catch (Exception ex) { ExceptionsWriter.saveEventsAndExceptions(ex, "Exceptions not handled", EventLogEntryType.Error); return(null); } }
public BusinessObjects.Models.User UserCheck(string userName, string password, string bankName) { try { string pquery = "select tblBanks.id,tblUsers.userName from tblUsers inner join tblBanks on tblUsers.bankId = tblBanks.id where tblUsers.userName = @userName and tblUsers.password = @password and tblBanks.name = @bankName"; List <SqlParameter> UserParams = new List <SqlParameter>(); UserParams.Add(new SqlParameter("@userName", userName)); UserParams.Add(new SqlParameter("@password", password)); UserParams.Add(new SqlParameter("@bankName", bankName)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); DataSet dataSet = dBHelper.executeAdapter(pquery, UserParams); BusinessObjects.Models.User user = new BusinessObjects.Models.User(); if (dataSet != null && dataSet.Tables[0].Rows.Count > 0) { user.bankId = Convert.ToInt32(dataSet.Tables[0].Rows[0][0].ToString()); user.userName = dataSet.Tables[0].Rows[0][1].ToString(); return(user); } return(null); } catch (Exception ex) { ExceptionsWriter.saveEventsAndExceptions(ex, "Exceptions not handled", EventLogEntryType.Error); return(null); } }
public ResultsEnum updateBranch(Branch branch) { try { string storedProc = "update tblBranches set enName = @enName,arName = @arName,active = @active OUTPUT INSERTED.IDENTITYCOL where id = @id and bankId = @bankId"; List <SqlParameter> branchParams = new List <SqlParameter>(); branchParams.Add(new SqlParameter("@id", branch.id)); branchParams.Add(new SqlParameter("@enName", branch.enName)); branchParams.Add(new SqlParameter("@arName", branch.arName)); branchParams.Add(new SqlParameter("@active", branch.active)); branchParams.Add(new SqlParameter("@bankId", branch.bankId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); int returnValue = Convert.ToInt32(dBHelper.executeScalar(storedProc, branchParams)); if ((sqlResultsEnum)returnValue == sqlResultsEnum.failed) { return(ResultsEnum.notFound); } else { return(ResultsEnum.updated); } } catch (Exception ex) { ExceptionsWriter.saveEventsAndExceptions(ex, "Exceptions not handled", EventLogEntryType.Error); return(ResultsEnum.notUpdated); } }
public BusinessObjects.Models.Bank getBankById(int id) { try { string pquery = "SELECT id,name FROM tblBanks WHERE id = @id"; List <SqlParameter> bankParams = new List <SqlParameter>(); bankParams.Add(new SqlParameter("@id", id)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); DataSet dataSet = dBHelper.executeAdapter(pquery, bankParams); BusinessObjects.Models.Bank pBank = new BusinessObjects.Models.Bank(); if (dataSet != null) { if (dataSet.Tables[0].Rows.Count > 0) { pBank.id = Convert.ToInt32(dataSet.Tables[0].Rows[0][0].ToString()); pBank.name = dataSet.Tables[0].Rows[0][1].ToString(); } else { pBank.id = 0; } } else { return(null); } return(pBank); } catch (Exception ex) { ExceptionsWriter.saveEventsAndExceptions(ex, "Exceptions not handled", EventLogEntryType.Error); return(null); } }
public List <T> selectButtonsbyScreenId <T>(int pScreenId, BusinessObjects.Models.btnType btnType) { try { List <T> lstButtons = new List <T>(); string pquery = "SELECT * FROM tbl" + btnType.ToString() + "Button where screenId = @screenId"; List <SqlParameter> screenParams = new List <SqlParameter>(); screenParams.Add(new SqlParameter("@screenId", pScreenId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); DataSet dataSet = dBHelper.executeAdapter(pquery, screenParams); foreach (DataRow dataRow in dataSet.Tables[0].Rows) { if (btnType == BusinessObjects.Models.btnType.ShowMessage) { var btn = new BusinessObjects.Models.ShowMessageButton(Convert.ToInt32(dataRow["id"]), dataRow["enName"].ToString(), dataRow["arName"].ToString(), dataRow["messageAR"].ToString(), dataRow["messageEN"].ToString(), Convert.ToInt32(dataRow["screenId"])); lstButtons.Add((T)(object)btn); } else { var btn = new BusinessObjects.Models.IssueTicketButton(Convert.ToInt32(dataRow["id"]), dataRow["enName"].ToString(), dataRow["arName"].ToString(), Convert.ToInt32(dataRow["serviceId"]), Convert.ToInt32(dataRow["screenId"])); lstButtons.Add((T)(object)btn); } } return(lstButtons); } catch (Exception ex) { ExceptionsWriter.saveEventsAndExceptions(ex, "Exceptions not handled", EventLogEntryType.Error); return(null); } }
public List <BusinessObjects.Models.Screen> selectScreensByBankId(BusinessObjects.Models.Bank pBank) { try { List <BusinessObjects.Models.Screen> lstScreens = new List <BusinessObjects.Models.Screen>(); string pquery = "SELECT id,name,isActive,bankId FROM tblScreens where bankId = @bankId"; List <SqlParameter> screenParams = new List <SqlParameter>(); screenParams.Add(new SqlParameter("@bankId", pBank.id)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); DataSet dataSet = dBHelper.executeAdapter(pquery, screenParams); if (dataSet != null) { foreach (DataRow dataRow in dataSet.Tables[0].Rows) { lstScreens.Add(new BusinessObjects.Models.Screen(Convert.ToInt32(dataRow["id"]), Convert.ToString(dataRow["name"]), Convert.ToBoolean(dataRow["isActive"]), Convert.ToInt32(dataRow["bankId"]))); } return(lstScreens); } else { return(null); } } catch (Exception ex) { ExceptionsWriter.saveExceptionToLogFile(ex); return(null); } }
public ResultsEnum insertCounter(Counter counter, int bankId) { try { string pquery = "sp_insertCounter"; List <SqlParameter> counterParams = new List <SqlParameter>(); counterParams.Add(new SqlParameter("@enName", counter.enName)); counterParams.Add(new SqlParameter("@arName", counter.arName)); counterParams.Add(new SqlParameter("@active", counter.active)); counterParams.Add(new SqlParameter("@type", counter.type)); counterParams.Add(new SqlParameter("@branchId", counter.branchId)); counterParams.Add(new SqlParameter("@bankId", bankId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); int returnValue = Convert.ToInt32(dBHelper.executeScalarProc(pquery, counterParams)); if ((sqlResultsEnum)returnValue == sqlResultsEnum.failed) { return(ResultsEnum.deleted); } else { return(ResultsEnum.inserted); } } catch (Exception ex) { ExceptionsWriter.saveExceptionToLogFile(ex); return(ResultsEnum.notInserted); } }
public sqlResultsEnum deleteCountersByBranchId(int branchId, int bankId) { try { string storedProc = string.Empty; storedProc = "sp_Delete_Allocate_Counter"; List <SqlParameter> branchParams = new List <SqlParameter>(); branchParams.Add(new SqlParameter("@branchId", branchId)); branchParams.Add(new SqlParameter("@bankId", bankId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); int returnValue = Convert.ToInt32(dBHelper.executeScalarProc(storedProc, branchParams)); if ((sqlResultsEnum)returnValue == sqlResultsEnum.failed) { return(sqlResultsEnum.failed); } else { return(sqlResultsEnum.success); } } catch (Exception ex) { ExceptionsWriter.saveEventsAndExceptions(ex, "Exceptions not handled", EventLogEntryType.Error); return(sqlResultsEnum.failed); } }
public sqlResultsEnum deleteBranchById(int branchId, int bankId) { try { string storedProc = string.Empty; storedProc = "delete from tblBranches OUTPUT DELETED.IDENTITYCOL where id = @id and bankId = @bankId"; List <SqlParameter> branchParams = new List <SqlParameter>(); branchParams.Add(new SqlParameter("@id", branchId)); branchParams.Add(new SqlParameter("@bankId", bankId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); int returnValue = Convert.ToInt32(dBHelper.executeScalar(storedProc, branchParams)); if ((sqlResultsEnum)returnValue == sqlResultsEnum.failed) { return(sqlResultsEnum.failed); } else { return(sqlResultsEnum.success); } } catch (Exception ex) { ExceptionsWriter.saveEventsAndExceptions(ex, "Exceptions not handled", EventLogEntryType.Error); return(sqlResultsEnum.failed); } }
public ResultsEnum deleteCounterById(int counterId, int bankId, int branchId) { try { string storedProc = string.Empty; storedProc = "delete from tblCounters OUTPUT DELETED.IDENTITYCOL where id = @id and branchId = @branchId and bankId = @bankId"; List <SqlParameter> counterParams = new List <SqlParameter>(); counterParams.Add(new SqlParameter("@id", counterId)); counterParams.Add(new SqlParameter("@bankId", bankId)); counterParams.Add(new SqlParameter("@branchId", branchId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); int returnValue = Convert.ToInt32(dBHelper.executeScalar(storedProc, counterParams)); if ((sqlResultsEnum)returnValue == sqlResultsEnum.failed) { return(ResultsEnum.notDeleted); } else { return(ResultsEnum.deleted); } } catch (Exception ex) { ExceptionsWriter.saveExceptionToLogFile(ex); return(ResultsEnum.notDeleted); } }
public ResultsEnum insertAllocateCounterService(int serviceId, int counterId, int bankId) { try { string storedProc = "sp_insertAllocateCounterService"; List <SqlParameter> allocateParams = new List <SqlParameter>(); allocateParams.Add(new SqlParameter("@id", counterId)); allocateParams.Add(new SqlParameter("@serviceId", serviceId)); allocateParams.Add(new SqlParameter("@bankId", bankId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); int returnValue = Convert.ToInt32(dBHelper.executeScalarProc(storedProc, allocateParams)); if ((sqlResultsEnum)returnValue == sqlResultsEnum.failed) { return(ResultsEnum.deleted); } else { return(ResultsEnum.inserted); } } catch (Exception ex) { ExceptionsWriter.saveExceptionToLogFile(ex); return(ResultsEnum.notInserted); } }
public ResultsEnum updateCounter(Counter counter, int bankId) { try { string storedProc = "update tblCounters set enName = @enName,arName = @arName,active = @active,type = @type OUTPUT INSERTED.IDENTITYCOL where id = @id and bankId = @bankId"; List <SqlParameter> counterParams = new List <SqlParameter>(); counterParams.Add(new SqlParameter("@id", counter.id)); counterParams.Add(new SqlParameter("@enName", counter.enName)); counterParams.Add(new SqlParameter("@arName", counter.arName)); counterParams.Add(new SqlParameter("@active", counter.active)); counterParams.Add(new SqlParameter("@type", counter.type)); counterParams.Add(new SqlParameter("@branchId", counter.branchId)); counterParams.Add(new SqlParameter("@bankId", bankId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); int returnValue = Convert.ToInt32(dBHelper.executeScalar(storedProc, counterParams)); if ((sqlResultsEnum)returnValue == sqlResultsEnum.failed) { return(ResultsEnum.deleted); } else { return(ResultsEnum.updated); } } catch (Exception ex) { ExceptionsWriter.saveExceptionToLogFile(ex); return(ResultsEnum.notUpdated); } }
public BusinessObjects.Models.Bank checkBankExist(BusinessObjects.Models.Bank pBank) { try { string pquery = "SELECT id,name FROM tblBanks WHERE name = @name"; List <SqlParameter> bankParams = new List <SqlParameter>(); bankParams.Add(new SqlParameter("@name", pBank.name)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); DataSet dataSet = dBHelper.executeAdapter(pquery, bankParams); if (dataSet != null) { if (dataSet.Tables[0].Rows.Count > 0) { pBank.id = Convert.ToInt32(dataSet.Tables[0].Rows[0][0].ToString()); } else { pBank.id = 0; } } else { return(null); } return(pBank); } catch (Exception ex) { ExceptionsWriter.saveExceptionToLogFile(ex); return(null); } }
public bool checkExist(string tableName, int id) { try { string pquery = "SELECT * FROM " + tableName + " WHERE id = @id"; List <SqlParameter> bankParams = new List <SqlParameter>(); bankParams.Add(new SqlParameter("@id", id)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); DataSet dataSet = dBHelper.executeAdapter(pquery, bankParams); if (dataSet != null) { if (dataSet.Tables[0].Rows.Count > 0) { return(true); } else { return(false); } } else { return(false); } } catch (Exception ex) { ExceptionsWriter.saveExceptionToLogFile(ex); return(false); } }
public ResultsEnum deleteCountersByBranchId(int branchId, int bankId) { try { string storedProc = string.Empty; storedProc = "sp_Delete_Allocate_Counter"; List <SqlParameter> branchParams = new List <SqlParameter>(); branchParams.Add(new SqlParameter("@branchId", branchId)); branchParams.Add(new SqlParameter("@bankId", bankId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); int returnValue = Convert.ToInt32(dBHelper.executeScalarProc(storedProc, branchParams)); if ((sqlResultsEnum)returnValue == sqlResultsEnum.failed) { return(ResultsEnum.notDeleted); } else { return(ResultsEnum.deleted); } } catch (Exception ex) { ExceptionsWriter.saveExceptionToLogFile(ex); return(ResultsEnum.notDeleted); } }
public ResultsEnum insertBranch(Branch branch) { try { string storedProc = "insert into tblBranches OUTPUT INSERTED.IDENTITYCOL values (@enName,@arName,@active,@bankId)"; List <SqlParameter> branchParams = new List <SqlParameter>(); branchParams.Add(new SqlParameter("@enName", branch.enName)); branchParams.Add(new SqlParameter("@arName", branch.arName)); branchParams.Add(new SqlParameter("@active", branch.active)); branchParams.Add(new SqlParameter("@bankId", branch.bankId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); int returnValue = Convert.ToInt32(dBHelper.executeScalar(storedProc, branchParams)); if ((sqlResultsEnum)returnValue == sqlResultsEnum.failed) { return(ResultsEnum.deleted); } else { return(ResultsEnum.inserted); } } catch (Exception ex) { ExceptionsWriter.saveExceptionToLogFile(ex); return(ResultsEnum.notInserted); } }
public ResultsEnum updateService(Service service) { try { string storedProc = "update tblservice set enName = @enName,arName = @arName,active = @active,maxNumOfTickets = @maxNumOfTickets OUTPUT INSERTED.IDENTITYCOL where id = @id and bankId = @bankId"; List <SqlParameter> serviceParams = new List <SqlParameter>(); serviceParams.Add(new SqlParameter("@id", service.id)); serviceParams.Add(new SqlParameter("@enName", service.enName)); serviceParams.Add(new SqlParameter("@arName", service.arName)); serviceParams.Add(new SqlParameter("@active", service.active)); serviceParams.Add(new SqlParameter("@maxNumOfTickets", service.maxNumOfTickets)); serviceParams.Add(new SqlParameter("@bankId", service.bankId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); int returnValue = Convert.ToInt32(dBHelper.executeScalar(storedProc, serviceParams)); if ((sqlResultsEnum)returnValue == sqlResultsEnum.failed) { return(ResultsEnum.deleted); } else { return(ResultsEnum.updated); } } catch (Exception ex) { ExceptionsWriter.saveExceptionToLogFile(ex); return(ResultsEnum.notUpdated); } }
public ResultsEnum insertService(Service service) { try { string pquery = "insert into tblService OUTPUT INSERTED.IDENTITYCOL values (@enName,@arName,@bankId,@active,@maxNumOfTickets)"; List <SqlParameter> serviceParams = new List <SqlParameter>(); serviceParams.Add(new SqlParameter("@enName", service.enName)); serviceParams.Add(new SqlParameter("@arName", service.arName)); serviceParams.Add(new SqlParameter("@bankId", service.bankId)); serviceParams.Add(new SqlParameter("@active", service.active)); serviceParams.Add(new SqlParameter("@maxNumOfTickets", service.maxNumOfTickets)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); int returnValue = Convert.ToInt32(dBHelper.executeScalar(pquery, serviceParams)); if ((sqlResultsEnum)returnValue == sqlResultsEnum.failed) { return(ResultsEnum.deleted); } else { return(ResultsEnum.inserted); } } catch (Exception ex) { ExceptionsWriter.saveExceptionToLogFile(ex); return(ResultsEnum.notInserted); } }
public BusinessObjects.Models.CustomIssueTicketAndShowMessageButtons selectIssueTicketAndShowMessageButtonsByBankName(string pBankName, int pBranchId, int pScreenId) { try { BusinessObjects.Models.CustomIssueTicketAndShowMessageButtons lstButtons = new BusinessObjects.Models.CustomIssueTicketAndShowMessageButtons(); string pquery = "sp_selectIssueTicketAndShowMessageButtonsByBankName"; List <SqlParameter> buttonsParams = new List <SqlParameter>(); buttonsParams.Add(new SqlParameter("@bankName", pBankName)); buttonsParams.Add(new SqlParameter("@branchId", pBranchId)); buttonsParams.Add(new SqlParameter("@screenId", pScreenId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); DataSet dataSet = dBHelper.executeAdapterProc(pquery, buttonsParams); if (dataSet == null) { return(null); } if (dataSet.Tables[0].Rows.Count != 0) { if (Convert.ToInt32((dataSet.Tables[0].Rows[0])["id"]) > 0) { List <BusinessObjects.Models.CustomIssueTicketButton> lstIssueTicketButtons = new List <BusinessObjects.Models.CustomIssueTicketButton>(); List <BusinessObjects.Models.CustomShowMessageButton> lstShowMessageButtons = new List <BusinessObjects.Models.CustomShowMessageButton>(); foreach (DataRow dataRow in dataSet.Tables[0].Rows) { if (dataRow["type"].ToString() == "IssueTicket") { BusinessObjects.Models.CustomIssueTicketButton issueTicketButton = new BusinessObjects.Models.CustomIssueTicketButton(); issueTicketButton.id = Convert.ToInt32(dataRow["id"]); issueTicketButton.enName = dataRow["enName"].ToString(); issueTicketButton.arName = dataRow["arName"].ToString(); issueTicketButton.serviceId = Convert.ToInt32(dataRow["serviceId"]); issueTicketButton.screenId = Convert.ToInt32(dataRow["screenId"]); lstIssueTicketButtons.Add(issueTicketButton); } else { BusinessObjects.Models.CustomShowMessageButton showMessageButton = new BusinessObjects.Models.CustomShowMessageButton(); showMessageButton.id = Convert.ToInt32(dataRow["id"]); showMessageButton.enName = dataRow["enName"].ToString(); showMessageButton.arName = dataRow["arName"].ToString(); showMessageButton.messageEN = dataRow["messageEN"].ToString(); showMessageButton.messageAR = dataRow["messageAR"].ToString(); showMessageButton.screenId = Convert.ToInt32(dataRow["screenId"]); lstShowMessageButtons.Add(showMessageButton); } } lstButtons.issueTicketButtons = lstIssueTicketButtons; lstButtons.showMessageButtons = lstShowMessageButtons; } } return(lstButtons); } catch (Exception ex) { ExceptionsWriter.saveEventsAndExceptions(ex, "Exceptions not handled", EventLogEntryType.Error); return(null); } }
public List <Service> selectServicesByBankId(int pBankId) { try { List <Service> lstServices = new List <Service>(); string pquery = "sp_selectServicesByBankId"; List <SqlParameter> ServiceParams = new List <SqlParameter>(); ServiceParams.Add(new SqlParameter("@bankId", pBankId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); DataSet dataSet = dBHelper.executeAdapterProc(pquery, ServiceParams); if (dataSet != null) { if (dataSet.Tables[0].Rows.Count != 0) { if (Convert.ToInt32((dataSet.Tables[0].Rows[0])["id"]) != 0) { foreach (DataRow dataRow in dataSet.Tables[0].Rows) { Service service = new Service(); service.id = Convert.ToInt32(dataRow["id"]); service.enName = dataRow["enName"].ToString(); service.arName = dataRow["arName"].ToString(); service.active = Convert.ToBoolean(dataRow["active"]); service.maxNumOfTickets = Convert.ToInt32(dataRow["maxNumOfTickets"]); if (dataRow["minimumServiceTime"] != System.DBNull.Value) { service.minimumServiceTime = Convert.ToInt32(dataRow["minimumServiceTime"]); } if (dataRow["maximumServiceTime"] != System.DBNull.Value) { service.maximumServiceTime = Convert.ToInt32(dataRow["maximumServiceTime"]); } service.bankId = Convert.ToInt32(dataRow["bankId"]); lstServices.Add(service); } } else { Service service = new Service(); service.id = 0; lstServices.Add(service); return(lstServices); } } return(lstServices); } else { return(null); } } catch (Exception ex) { ExceptionsWriter.saveEventsAndExceptions(ex, "Exceptions not handled", EventLogEntryType.Error); return(null); } }
public List <Counter> selectCountersByBranchId(int pBranchId, int pBankId) { try { List <Counter> lstCounters = new List <Counter>(); string pquery = "sp_selectCountersByBranchId"; List <SqlParameter> ServiceParams = new List <SqlParameter>(); ServiceParams.Add(new SqlParameter("@branchId", pBranchId)); ServiceParams.Add(new SqlParameter("@bankId", pBankId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); DataSet dataSet = dBHelper.executeAdapterProc(pquery, ServiceParams); if (dataSet != null) { if (dataSet.Tables[0].Rows.Count != 0) { if (Convert.ToInt32((dataSet.Tables[0].Rows[0])["id"]) != 0) { foreach (DataRow dataRow in dataSet.Tables[0].Rows) { Counter counter = new Counter(); counter.id = Convert.ToInt32(dataRow["id"]); counter.enName = dataRow["enName"].ToString(); counter.arName = dataRow["arName"].ToString(); counter.active = Convert.ToBoolean(dataRow["active"]); counter.type = dataRow["type"].ToString(); counter.branchId = Convert.ToInt32(dataRow["branchId"]); lstCounters.Add(counter); } } else { Counter counter = new Counter(); counter.id = 0; lstCounters.Add(counter); return(lstCounters); } } return(lstCounters); } else { return(null); } } catch (Exception ex) { ExceptionsWriter.saveExceptionToLogFile(ex); return(null); } }
public List <AllocateCounterService> selectAllocateCounterService(int counterId, int bankId) { try { List <AllocateCounterService> lstAllocateCounterService = new List <AllocateCounterService>(); string pquery = "sp_selectAllocateCounterService"; List <SqlParameter> AllocateCounterServiceParams = new List <SqlParameter>(); AllocateCounterServiceParams.Add(new SqlParameter("@counterId", counterId)); AllocateCounterServiceParams.Add(new SqlParameter("@bankId", bankId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); DataSet dataSet = dBHelper.executeAdapterProc(pquery, AllocateCounterServiceParams); if (dataSet != null) { if (dataSet.Tables[0].Rows.Count != 0) { if (Convert.ToInt32((dataSet.Tables[0].Rows[0])["id"]) > 0) { foreach (DataRow dataRow in dataSet.Tables[0].Rows) { AllocateCounterService allocateCounterService = new AllocateCounterService(); allocateCounterService.id = Convert.ToInt32(dataRow["id"]); allocateCounterService.counterId = Convert.ToInt32(dataRow["counterId"]); allocateCounterService.serviceId = Convert.ToInt32(dataRow["serviceId"]); allocateCounterService.serviceEnName = dataRow["serviceEnName"].ToString(); allocateCounterService.serviceArName = dataRow["serviceArName"].ToString(); lstAllocateCounterService.Add(allocateCounterService); } } else { AllocateCounterService allocateCounterService = new AllocateCounterService(); allocateCounterService.id = Convert.ToInt32((dataSet.Tables[0].Rows[0])["id"]); lstAllocateCounterService.Add(allocateCounterService); return(lstAllocateCounterService); } } return(lstAllocateCounterService); } else { return(null); } } catch (Exception ex) { ExceptionsWriter.saveExceptionToLogFile(ex); return(null); } }
public Service selectServiceById(int serviceId, int bankId) { try { string pquery = "SELECT * FROM tblService where id = @serviceId and bankId = @bankId"; List <SqlParameter> serviceParams = new List <SqlParameter>(); serviceParams.Add(new SqlParameter("@serviceId", serviceId)); serviceParams.Add(new SqlParameter("@bankId", bankId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); DataSet dataSet = dBHelper.executeAdapter(pquery, serviceParams); if (dataSet != null) { Service service = new Service(); if (dataSet.Tables[0].Rows.Count != 0) { DataRow dataRow = dataSet.Tables[0].Rows[0]; service.id = Convert.ToInt32(dataRow["id"]); service.enName = dataRow["enName"].ToString(); service.arName = dataRow["arName"].ToString(); service.active = Convert.ToBoolean(dataRow["active"]); service.maxNumOfTickets = Convert.ToInt32(dataRow["maxNumOfTickets"]); if (dataRow["minimumServiceTime"] != System.DBNull.Value) { service.minimumServiceTime = Convert.ToInt32(dataRow["minimumServiceTime"]); } if (dataRow["maximumServiceTime"] != System.DBNull.Value) { service.maximumServiceTime = Convert.ToInt32(dataRow["maximumServiceTime"]); } service.bankId = Convert.ToInt32(dataRow["bankId"]); return(service); } else { service.id = 0; return(service); } } else { return(null); } } catch (Exception ex) { ExceptionsWriter.saveEventsAndExceptions(ex, "Exceptions not handled", EventLogEntryType.Error); return(null); } }
public void updateActiveScreen(int pScreenId) { try { string pquery = "update tblScreens set isActive = 0 where id != @id"; List <SqlParameter> screenParams = new List <SqlParameter>(); screenParams.Add(new SqlParameter("@id", pScreenId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); dBHelper.executeScalar(pquery, screenParams); } catch (Exception ex) { ExceptionsWriter.saveExceptionToLogFile(ex); } }
public void updateActiveScreen(int pScreenId) { try { string pquery = "update tblScreens set isActive = 0 where id != @id"; List <SqlParameter> screenParams = new List <SqlParameter>(); screenParams.Add(new SqlParameter("@id", pScreenId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); dBHelper.executeScalar(pquery, screenParams); } catch (Exception ex) { ExceptionsWriter.saveEventsAndExceptions(ex, "Exceptions not handled", EventLogEntryType.Error); } }
public List <Branch> selectBranchesByBankId(int pBankId) { try { List <Branch> lstBranches = new List <Branch>(); string storedProc = "sp_selectBranchesByBankId"; List <SqlParameter> branchParams = new List <SqlParameter>(); branchParams.Add(new SqlParameter("@bankId", pBankId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); DataSet dataSet = dBHelper.executeAdapterProc(storedProc, branchParams); if (dataSet != null) { if (dataSet.Tables[0].Rows.Count != 0) { if (Convert.ToInt32((dataSet.Tables[0].Rows[0])["id"]) != 0) { foreach (DataRow dataRow in dataSet.Tables[0].Rows) { Branch branch = new Branch(); branch.id = Convert.ToInt32(dataRow["id"]); branch.enName = dataRow["enName"].ToString(); branch.arName = dataRow["arName"].ToString(); branch.active = Convert.ToBoolean(dataRow["active"]); branch.bankId = Convert.ToInt32(dataRow["bankId"]); lstBranches.Add(branch); } } else { Branch branch = new Branch(); branch.id = 0; lstBranches.Add(branch); return(lstBranches); } } return(lstBranches); } else { return(null); } } catch (Exception ex) { ExceptionsWriter.saveEventsAndExceptions(ex, "Exceptions not handled", EventLogEntryType.Error); return(null); } }
public int deleteScreenById(int pScreenId) { try { string pquery = "delete from tblScreens where id = @id"; List <SqlParameter> screenParams = new List <SqlParameter>(); screenParams.Add(new SqlParameter("@id", pScreenId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); dBHelper.executeNonQuery(pquery, screenParams); return(1); } catch (Exception ex) { ExceptionsWriter.saveExceptionToLogFile(ex); return(0); } }
public bool checkIfScreenIsDeleted(int pScreenId) { try { string pquery = "select * from tblScreens where id = @id"; List <SqlParameter> screenParams = new List <SqlParameter>(); screenParams.Add(new SqlParameter("@id", pScreenId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); var rowEffected = dBHelper.executeScalar(pquery, screenParams); return(rowEffected == null ? true : false); } catch (Exception ex) { ExceptionsWriter.saveExceptionToLogFile(ex); return(false); } }
public int deleteScreenById(int pScreenId) { try { string pquery = "delete from tblScreens where id = @id"; List <SqlParameter> screenParams = new List <SqlParameter>(); screenParams.Add(new SqlParameter("@id", pScreenId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); dBHelper.executeNonQuery(pquery, screenParams); return(1); } catch (Exception ex) { ExceptionsWriter.saveEventsAndExceptions(ex, "Exceptions not handled", EventLogEntryType.Error); return(0); } }
public bool checkIfScreenIsBusy(int pScreenId) { try { string pquery = "select * from tblScreens where id = @id and isBusy = 1"; List <SqlParameter> screenParams = new List <SqlParameter>(); screenParams.Add(new SqlParameter("@id", pScreenId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); var rowEffected = dBHelper.executeScalar(pquery, screenParams); return(rowEffected == null ? false : true); } catch (Exception ex) { ExceptionsWriter.saveEventsAndExceptions(ex, "Exceptions not handled", EventLogEntryType.Error); return(false); } }