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 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 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 <BusinessObjects.Models.Screen> selectScreensByBankId(BusinessObjects.Models.Bank pBank)
{
try
{
DataAccessLayer.DALScreen.DALScreen screenDAL = new DataAccessLayer.DALScreen.DALScreen();
return(screenDAL.selectScreensByBankId(pBank));
}
catch (Exception ex)
{
ExceptionsWriter.saveExceptionToLogFile(ex);
return(null);
}
}
public BusinessObjects.Models.Bank insertBank(BusinessObjects.Models.Bank pBank)
{
try
{
DataAccessLayer.DALBank.DALBank dALbank = new DataAccessLayer.DALBank.DALBank();
return(dALbank.insertBank(pBank));
}
catch (Exception ex)
{
ExceptionsWriter.saveEventsAndExceptions(ex, "Exceptions not handled", EventLogEntryType.Error);
return(null);
}
}
public BusinessObjects.Models.Bank insertBank(BusinessObjects.Models.Bank pBank)
{
try
{
DataAccessLayer.DALBank.DALBank dALbank = new DataAccessLayer.DALBank.DALBank();
return(dALbank.insertBank(pBank));
}
catch (Exception ex)
{
ExceptionsWriter.saveExceptionToLogFile(ex);
return(null);
}
}
public List <BusinessObjects.Models.Screen> selectScreensByBankId(BusinessObjects.Models.Bank pBank)
{
try
{
DataAccessLayer.DALScreen.DALScreen screenDAL = new DataAccessLayer.DALScreen.DALScreen();
return(screenDAL.selectScreensByBankId(pBank));
}
catch (Exception ex)
{
ExceptionsWriter.saveEventsAndExceptions(ex, "Exceptions not handled", EventLogEntryType.Error);
return(null);
}
}
public BusinessObjects.Models.Bank insertBank(BusinessObjects.Models.Bank pBank)
{
try
{
string pquery = "insert into tblBanks OUTPUT INSERTED.IDENTITYCOL values (@name)";
List <SqlParameter> bankParams = new List <SqlParameter>();
bankParams.Add(new SqlParameter("@name", pBank.name));
DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper();
pBank.id = Convert.ToInt32(dBHelper.executeScalar(pquery, bankParams));
return(pBank);
}
catch (Exception ex)
{
ExceptionsWriter.saveExceptionToLogFile(ex);
return(null);
}
}
