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);
}
}
