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