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