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.IssueTicketButton updateIssueTicketButton(BusinessObjects.Models.IssueTicketButton pButton)
{
try
{
string pquery = "update tblIssueTicketButton set enName = @enName,ARName = @arName,serviceId = @serviceId 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("@serviceId", pButton.serviceId));
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.IssueTicketButton insertIssueTicketButton(BusinessObjects.Models.IssueTicketButton pButton)
{
try
{
string pquery = "insert into tblIssueTicketButton OUTPUT INSERTED.IDENTITYCOL values (@enName,@arName,@serviceId,@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("@serviceId", pButton.serviceId));
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);
}
}
