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 bool checkIfButtonIsDeleted(int pButtonId, BusinessObjects.Models.btnType btnType) { try { DataAccessLayer.DALButton.DALButton dALButton = new DataAccessLayer.DALButton.DALButton(); return(dALButton.checkIfButtonIsDeleted(pButtonId, btnType)); } catch (Exception ex) { ExceptionsWriter.saveExceptionToLogFile(ex); return(false); } }
public List <T> selectButtonsbyScreenId <T>(int pScreenId, BusinessObjects.Models.btnType btnType) { try { DataAccessLayer.DALButton.DALButton button = new DataAccessLayer.DALButton.DALButton(); return(button.selectButtonsbyScreenId <T>(pScreenId, btnType)); } catch (Exception ex) { ExceptionsWriter.saveExceptionToLogFile(ex); return(null); } }
public bool checkIfButtonIsDeleted(int pButtonId, BusinessObjects.Models.btnType btnType) { try { string pquery = String.Format("select * from tbl{0}Button where id = @id", btnType.ToString()); List <SqlParameter> screenParams = new List <SqlParameter>(); screenParams.Add(new SqlParameter("@id", pButtonId)); DALDBHelper.DALDBHelper dBHelper = new DALDBHelper.DALDBHelper(); var rowEffected = dBHelper.executeScalar(pquery, screenParams); return(rowEffected != null ? true : false); } catch (Exception ex) { ExceptionsWriter.saveEventsAndExceptions(ex, "Exceptions not handled", EventLogEntryType.Error); return(false); } }