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.Screen updateScreen(BusinessObjects.Models.Screen pScreen)
{
try
{
string pquery = "update tblScreens set name = @name,isActive = @isActive where id = @id";
List <SqlParameter> screenParams = new List <SqlParameter>();
screenParams.Add(new SqlParameter("@name", pScreen.name));
screenParams.Add(new SqlParameter("@isActive", pScreen.isActive));
screenParams.Add(new SqlParameter("@id", pScreen.id));
DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper();
dBHelper.executeNonQuery(pquery, screenParams);
if (pScreen.isActive)
{
updateActiveScreen(pScreen.id);
}
return(pScreen);
}
catch (Exception ex)
{
ExceptionsWriter.saveExceptionToLogFile(ex);
return(null);
}
}
public BusinessObjects.Models.Screen insertScreen(BusinessObjects.Models.Screen pScreen)
{
try
{
string pquery = "insert into tblScreens OUTPUT INSERTED.IDENTITYCOL values (@name,@isActive,@bankId,0)";
List <SqlParameter> screenParams = new List <SqlParameter>();
screenParams.Add(new SqlParameter("@name", pScreen.name));
screenParams.Add(new SqlParameter("@isActive", pScreen.isActive));
screenParams.Add(new SqlParameter("@bankId", pScreen.bankId));
DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper();
pScreen.id = Convert.ToInt32(dBHelper.executeScalar(pquery, screenParams));
if (pScreen.isActive)
{
updateActiveScreen(pScreen.id);
}
return(pScreen);
}
catch (Exception ex)
{
ExceptionsWriter.saveExceptionToLogFile(ex);
return(null);
}
}
private void getScreen_Click(object sender, EventArgs e)
{
try
{
if (checkUserInfoFill())
{
BusinessObjects.Models.Screen screen = new BusinessObjects.Models.Screen();
string credentials = SetCredentials(txtUserName.Text, txtPassword.Text, txtBankName.Text);
using (OperationContextScope scope =
new OperationContextScope(client.InnerChannel))
{
HttpRequestMessageProperty request = new HttpRequestMessageProperty();
request.Headers[System.Net.HttpRequestHeader.Authorization] = "Basic " + credentials;
OperationContext.Current.OutgoingMessageProperties.Add(HttpRequestMessageProperty.Name, request);
screen = client.getScreen(txtBankName.Text);
}
if (screen == null || screen.id == 0)
{
gv_Screen.DataSource = null;
MessageBox.Show("Item not found");
return;
}
List <BusinessObjects.Models.Screen> lstScreens = new List <BusinessObjects.Models.Screen>();
lstScreens.Add(screen);
gv_Screen.DataSource = lstScreens;
}
}
catch (Exception ex)
{
if (ex.Message != "Access is denied.")
{
ExceptionsWriter.saveEventsAndExceptions(ex, "Exceptions not handled", EventLogEntryType.Error);
}
MessageBox.Show(ex.Message);
}
}
public BusinessObjects.Models.Screen insertScreenAndEditButtons(BusinessObjects.Models.Screen pScreen
, List <BusinessObjects.Models.ShowMessageButton> lstShowMessageButtons, List <BusinessObjects.Models.IssueTicketButton> lstIssueTicketButtons)
{
try
{
DataAccessLayer.DALScreen.DALScreen screenDAL = new DataAccessLayer.DALScreen.DALScreen();
BusinessObjects.Models.Screen screen;
using (TransactionScope scope = new TransactionScope())
{
screen = screenDAL.insertScreen(pScreen);
DataAccessLayer.DALButton.DALButton button = new DataAccessLayer.DALButton.DALButton();
foreach (BusinessObjects.Models.IssueTicketButton pbutton in lstIssueTicketButtons)
{
if (pbutton.id == 0)
{
pbutton.screenId = screen.id;
BusinessObjects.Models.IssueTicketButton btnInsertCheck = button.insertIssueTicketButton(pbutton);
if (btnInsertCheck == null)
{
return(null);
}
}
else if (pbutton.updated == true)
{
BusinessObjects.Models.IssueTicketButton btnUpdateCheck = button.updateIssueTicketButton(pbutton);
if (btnUpdateCheck == null)
{
return(null);
}
}
}
foreach (BusinessObjects.Models.ShowMessageButton pbutton in lstShowMessageButtons)
{
if (pbutton.id == 0)
{
pbutton.screenId = screen.id;
BusinessObjects.Models.ShowMessageButton btnInsertCheck = button.insertShowMessageButton(pbutton);
if (btnInsertCheck == null)
{
return(null);
}
}
else if (pbutton.updated == true)
{
BusinessObjects.Models.ShowMessageButton btnUpdateCheck = button.updateShowMessageButton(pbutton);
if (btnUpdateCheck == null)
{
return(null);
}
}
}
scope.Complete();
}
return(screen);
}
catch (Exception ex)
{
ExceptionsWriter.saveExceptionToLogFile(ex);
return(null);
}
}
public BusinessObjects.Models.Screen updateScreenAndEditButtons(BusinessObjects.Models.Screen pScreen
, List <BusinessObjects.Models.ShowMessageButton> lstShowMessageButtons, List <BusinessObjects.Models.IssueTicketButton> lstIssueTicketButtons)
{
try
{
DataAccessLayer.DALScreen.DALScreen screenDAL = new DataAccessLayer.DALScreen.DALScreen();
BusinessObjects.Models.Screen screen;
using (TransactionScope scope = new TransactionScope())
{
screen = screenDAL.updateScreen(pScreen);
DataAccessLayer.DALButton.DALButton button = new DataAccessLayer.DALButton.DALButton();
IDictionary <int, string> pButtonsDetailsIds = new Dictionary <int, string>();
foreach (BusinessObjects.Models.IssueTicketButton pbutton in lstIssueTicketButtons)
{
if (pbutton.id == 0)
{
pbutton.screenId = screen.id;
BusinessObjects.Models.IssueTicketButton btnInsertCheck = button.insertIssueTicketButton(pbutton);
if (btnInsertCheck == null)
{
return(null);
}
}
else if (pbutton.isDeleted)
{
pButtonsDetailsIds.Add(pbutton.id, BusinessObjects.Models.btnType.IssueTicket.ToString());
}
else if (pbutton.updated)
{
BusinessObjects.Models.IssueTicketButton btnUpdateCheck = button.updateIssueTicketButton(pbutton);
if (btnUpdateCheck == null)
{
return(null);
}
}
}
foreach (BusinessObjects.Models.ShowMessageButton pbutton in lstShowMessageButtons)
{
if (pbutton.id == 0)
{
pbutton.screenId = screen.id;
BusinessObjects.Models.ShowMessageButton btnInsertCheck = button.insertShowMessageButton(pbutton);
if (btnInsertCheck == null)
{
return(null);
}
}
else if (pbutton.isDeleted)
{
pButtonsDetailsIds.Add(pbutton.id, BusinessObjects.Models.btnType.ShowMessage.ToString());
}
else if (pbutton.updated == true)
{
BusinessObjects.Models.ShowMessageButton btnUpdateCheck = button.updateShowMessageButton(pbutton);
if (btnUpdateCheck == null)
{
return(null);
}
}
}
int DeleteCheck = button.deleteButtonsConditional(pButtonsDetailsIds, "id");
if (DeleteCheck != 1)
{
return(null);
}
scope.Complete();
}
return(screen);
}
catch (Exception ex)
{
ExceptionsWriter.saveExceptionToLogFile(ex);
return(null);
}
}
