public bool UpdateGlueStation(tblGlueMaster tblglueMaster)
{
try
{
var masterData = _entity.tblGlueMaster.FirstOrDefault(x => x.Code == tblglueMaster.Code);
if (masterData != null)
{
if (!string.IsNullOrEmpty(tblglueMaster.Code))
{
masterData.Passed = tblglueMaster.Passed;
}
if (tblglueMaster.UpdatedBy != null)
{
masterData.UpdatedBy = tblglueMaster.UpdatedBy;
}
if (tblglueMaster.UpdatedDate != null)
{
masterData.UpdatedDate = tblglueMaster.UpdatedDate;
}
_entity.Entry(masterData).State = EntityState.Modified;
_entity.SaveChanges();
}
}
catch (Exception exception)
{
throw exception;
}
return(true);
}
public tblGlueMaster GetGlueStationInfo(tblGlueMaster tblGlueMaster)
{
try
{
return(_iLcdGlueStation.GetGlueStationInfo(tblGlueMaster));
}
catch (Exception ex) { throw ex; }
}
public Result UpdateGlueStation(tblGlueMaster tblglueMaster)
{
try
{
return(_lcdGlueStationManager.UpdateGlueStation(tblglueMaster));
}
catch (Exception ex)
{
return(new Result {
IsSuccess = false, Message = ex.Message
});
}
}
public bool InsertGlueStation(tblGlueMaster tblGlueMaster)
{
try
{
_entity.tblGlueMaster.Add(tblGlueMaster);
_entity.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
return(true);
}
public tblGlueMaster GetGlueStationInfo(tblGlueMaster tblGlueMaster)
{
var tplcd = new tblGlueMaster();
try
{
tplcd = _lcdGlueStationManager.GetGlueStationInfo(tblGlueMaster);
}
catch (Exception ex)
{
}
return(tplcd);
}
public tblGlueMaster GetGlueStationInfo(tblGlueMaster tblGlueMaster)
{
tblGlueMaster master;
try
{
master =
_entity.tblGlueMaster.WhereIf(tblGlueMaster.Code != null,
x => x.Code == tblGlueMaster.Code)
.WhereIf(tblGlueMaster.Passed != null, x => x.Passed == tblGlueMaster.Passed)
.WhereIf(tblGlueMaster.AddedBy != null, x => x.AddedBy == tblGlueMaster.AddedBy)
.FirstOrDefault();
}
catch (Exception ex)
{
throw ex;
}
return(master);
}
public Result UpdateGlueStation(tblGlueMaster tblglueMaster)
{
try
{
using (
var transaction = new TransactionScope(TransactionScopeOption.Required,
ApplicationState.TransactionOptions))
{
var result = new Result {
IsSuccess = _iLcdGlueStation.UpdateGlueStation(tblglueMaster)
};
if (result.IsSuccess)
{
transaction.Complete();
}
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult InsertGlueStation(tblGlueMaster glueMaster, List <tblLcdGlueRework> reworkList)
{
var userId = (long)_dictionary[2].Id;
var projectId = (long)_dictionary[3].Id;
var result = new Result();
try
{
var isExists = _lcdGlueStationService.GetGlueStationInfo(new tblGlueMaster {
Code = glueMaster.Code
});
var workingProject =
_lcdGlueStationService.LoadWorkingModelData()
.FirstOrDefault(a => a.AddedBy == userId && a.CurentlyRunning == "Y");
if (isExists == null)
{
if (workingProject != null)
{
var tblGlueMaster = new tblGlueMaster();
tblGlueMaster.Code = glueMaster.Code;
tblGlueMaster.ProjectId = workingProject.ProjectId;
tblGlueMaster.ProjectName = workingProject.ProjectName;
tblGlueMaster.Passed = glueMaster.Passed.ToUpper();
tblGlueMaster.AddedBy = userId;
tblGlueMaster.AddedDate = DateTime.Now;
result = _lcdGlueStationService.InsertGlueStation(tblGlueMaster);
if (result.IsSuccess == true && glueMaster.Passed.ToUpper() == "N")
{
var Reresult = new Result();
var rework = new tblLcdGlueRework();
foreach (tblLcdGlueRework item in reworkList)
{
//rework.LineId = lineId;
rework.ProjectId = workingProject.ProjectId;
rework.ProjectName = workingProject.ProjectName;
rework.Code = glueMaster.Code;
rework.Issue = item.Issue;
rework.FailedFrom = "GLUE";
rework.Status = "P";
rework.AddedBy = userId;
rework.AddedDate = DateTime.Now;
Reresult = _lcdGlueStationService.InsertTpLcdReworkStation(rework);
}
}
}
else
{
result.Message = "No Project Or Model Found";
}
}
else
{
if (workingProject != null)
{
var tblglueMaster = new tblGlueMaster();
tblglueMaster.Code = glueMaster.Code;
//tblTpLcdMaster.ProjectId = workingProject.ProjectId;
//tblTpLcdMaster.ProjectName = workingProject.ProjectName;
tblglueMaster.Passed = glueMaster.Passed.ToUpper();
tblglueMaster.UpdatedBy = userId;
tblglueMaster.UpdatedDate = DateTime.Now;
result = _lcdGlueStationService.UpdateGlueStation(tblglueMaster);
if (result.IsSuccess == true && glueMaster.Passed.ToUpper() == "N")
{
var Reresult = new Result();
var rework = new tblLcdGlueRework();
foreach (tblLcdGlueRework item in reworkList)
{
//rework.LineId = lineId;
rework.ProjectId = isExists.ProjectId;
rework.ProjectName = workingProject.ProjectName;
rework.Code = glueMaster.Code;
rework.Issue = item.Issue;
rework.FailedFrom = "GLUE";
rework.Status = "P";
rework.AddedBy = userId;
rework.AddedDate = DateTime.Now;
Reresult = _lcdGlueStationService.InsertTpLcdReworkStation(rework);
}
}
}
else
{
result.Message = "No Project Or Model Found";
}
}
}
catch (Exception)
{
throw;
}
return(Json(result));
}
