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 BusinessObjects.Models.ShowMessageButton updateShowMessageButton(BusinessObjects.Models.ShowMessageButton pButton) { try { string pquery = "update tblShowMessageButton set enName = @enName,arName = @arName,messageAR = @messageAR,messageEN = @messageEN where id = @id"; List <SqlParameter> screenParams = new List <SqlParameter>(); screenParams.Add(new SqlParameter("@id", pButton.id)); screenParams.Add(new SqlParameter("@enName", pButton.enName)); screenParams.Add(new SqlParameter("@arName", pButton.arName)); screenParams.Add(new SqlParameter("@messageEN", pButton.messageEN)); screenParams.Add(new SqlParameter("@messageAR", pButton.messageAR)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); dBHelper.executeNonQuery(pquery, screenParams); return(pButton); } catch (Exception ex) { ExceptionsWriter.saveEventsAndExceptions(ex, "Exceptions not handled", EventLogEntryType.Error); return(null); } }
public BusinessObjects.Models.ShowMessageButton insertShowMessageButton(BusinessObjects.Models.ShowMessageButton pButton) { try { string pquery = "insert into tblShowMessageButton OUTPUT INSERTED.IDENTITYCOL values (@enName,@arName,@messageEN,@messageAR,@screenId,0)"; List <SqlParameter> screenParams = new List <SqlParameter>(); screenParams.Add(new SqlParameter("@enName", pButton.enName)); screenParams.Add(new SqlParameter("@arName", pButton.arName)); screenParams.Add(new SqlParameter("@messageEN", pButton.messageEN)); screenParams.Add(new SqlParameter("@messageAR", pButton.messageAR)); screenParams.Add(new SqlParameter("@screenId", pButton.screenId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); pButton.id = Convert.ToInt32(dBHelper.executeScalar(pquery, screenParams)); return(pButton); } catch (Exception ex) { ExceptionsWriter.saveEventsAndExceptions(ex, "Exceptions not handled", EventLogEntryType.Error); return(null); } }
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); } }