public ServiceIssueModel GetServiceIssueInfo(int ID = 0)
{
ShomaRMEntities db = new ShomaRMEntities();
ServiceIssueModel model = new ServiceIssueModel();
var Serissue = db.tbl_Issue.Where(p => p.IssueID == ID).FirstOrDefault();
if (Serissue != null)
{
model.IssueID = Serissue.IssueID;
model.CausingIssueID = Serissue.CausingIssueID;
model.ServiceIssueID = Serissue.ServiceIssueID;
model.Issue = Serissue.Issue;
}
return(model);
}
public long SaveUpdateServiceIssue(ServiceIssueModel model)
{
ShomaRMEntities db = new ShomaRMEntities();
var userNameExists = db.tbl_Issue.Where(p => p.IssueID != model.IssueID && p.Issue == model.Issue).FirstOrDefault();
if (userNameExists == null)
{
if (model.IssueID == 0)
{
var IssueData = new tbl_Issue()
{
CausingIssueID = model.CausingIssueID,
ServiceIssueID = model.ServiceIssueID,
Issue = model.Issue,
};
db.tbl_Issue.Add(IssueData);
db.SaveChanges();
model.IssueID = IssueData.IssueID;
}
else
{
var SIssueData = db.tbl_Issue.Where(p => p.IssueID == model.IssueID).FirstOrDefault();
if (SIssueData != null)
{
SIssueData.CausingIssueID = model.CausingIssueID;
SIssueData.ServiceIssueID = model.ServiceIssueID;
SIssueData.Issue = model.Issue;
db.SaveChanges();
}
else
{
throw new Exception(model.Issue + " not exists in the system.");
}
}
return(model.IssueID);
}
else
{
throw new Exception(model.Issue + " already exists in the system.");
}
}