public bool UpdateTpLcdStation(tblTpLcdMaster tblTpLcdMaster)
{
try
{
var masterData = _entity.tblTpLcdMaster.FirstOrDefault(x => x.Code == tblTpLcdMaster.Code);
if (masterData != null)
{
if (!string.IsNullOrEmpty(tblTpLcdMaster.Code))
{
masterData.Passed = tblTpLcdMaster.Passed;
}
if (tblTpLcdMaster.UpdatedBy != null)
{
masterData.UpdatedBy = tblTpLcdMaster.UpdatedBy;
}
if (tblTpLcdMaster.UpdatedDate != null)
{
masterData.UpdatedDate = tblTpLcdMaster.UpdatedDate;
}
_entity.Entry(masterData).State = EntityState.Modified;
_entity.SaveChanges();
}
}
catch (Exception)
{
throw;
}
return(true);
}
public tblTpLcdMaster GetTpLcdStationInfo(tblTpLcdMaster tblTpLcdMaster)
{
try
{
return(_iLcdGlueStation.GetTpLcdStationInfo(tblTpLcdMaster));
}
catch (Exception ex) { throw ex; }
}
public Result InsertTpLcdStation(tblTpLcdMaster tblTpLcdMaster)
{
try
{
return(_lcdGlueStationManager.InsertTpLcdStation(tblTpLcdMaster));
}
catch (Exception ex)
{
return(new Result {
IsSuccess = false, Message = ex.Message
});
}
}
public bool InsertTpLcdStation(tblTpLcdMaster tblTpLcdMaster)
{
try
{
_entity.tblTpLcdMaster.Add(tblTpLcdMaster);
_entity.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
return(true);
}
public tblTpLcdMaster GetTpLcdStationInfo(tblTpLcdMaster tblTpLcdMaster)
{
var tplcd = new tblTpLcdMaster();
try
{
tplcd = _lcdGlueStationManager.GetTpLcdStationInfo(tblTpLcdMaster);
}
catch (Exception ex)
{
}
return(tplcd);
}
public tblTpLcdMaster GetTpLcdStationInfo(tblTpLcdMaster tblTpLcdMaster)
{
tblTpLcdMaster master;
try
{
master =
_entity.tblTpLcdMaster.WhereIf(tblTpLcdMaster.Code != null,
x => x.Code == tblTpLcdMaster.Code)
.WhereIf(tblTpLcdMaster.Passed != null, x => x.Passed == tblTpLcdMaster.Passed)
.WhereIf(tblTpLcdMaster.AddedBy != null, x => x.AddedBy == tblTpLcdMaster.AddedBy)
.FirstOrDefault();
}
catch (Exception ex)
{
throw ex;
}
return(master);
}
public Result InsertTpLcdStation(tblTpLcdMaster tblTpLcdMaster)
{
try
{
using (
var transaction = new TransactionScope(TransactionScopeOption.Required,
ApplicationState.TransactionOptions))
{
var result = new Result {
IsSuccess = _iLcdGlueStation.InsertTpLcdStation(tblTpLcdMaster)
};
if (result.IsSuccess)
{
transaction.Complete();
}
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult InsertTpLcdStation(tblTpLcdMaster tpLcdData, List <tblLcdGlueRework> reworkList)
{
var userId = (long)_dictionary[2].Id;
var projectId = (long)_dictionary[3].Id;
var result = new Result();
try
{
var isExists = _lcdGlueStationService.GetTpLcdStationInfo(new tblTpLcdMaster {
Code = tpLcdData.Code
});
var workingProject =
_lcdGlueStationService.LoadWorkingModelData()
.FirstOrDefault(a => a.AddedBy == userId && a.CurentlyRunning == "Y");
if (isExists == null)
{
if (workingProject != null)
{
var tblTpLcdMaster = new tblTpLcdMaster();
tblTpLcdMaster.Code = tpLcdData.Code;
tblTpLcdMaster.ProjectId = workingProject.ProjectId;
tblTpLcdMaster.ProjectName = workingProject.ProjectName;
tblTpLcdMaster.Passed = tpLcdData.Passed.ToUpper();
tblTpLcdMaster.AddedBy = userId;
tblTpLcdMaster.AddedDate = DateTime.Now;
result = _lcdGlueStationService.InsertTpLcdStation(tblTpLcdMaster);
if (result.IsSuccess == true && tpLcdData.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 = tpLcdData.Code;
rework.Issue = item.Issue;
rework.FailedFrom = "TPLCD";
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 tblTpLcdMaster = new tblTpLcdMaster();
tblTpLcdMaster.Code = tpLcdData.Code;
//tblTpLcdMaster.ProjectId = workingProject.ProjectId;
//tblTpLcdMaster.ProjectName = workingProject.ProjectName;
tblTpLcdMaster.Passed = tpLcdData.Passed.ToUpper();
tblTpLcdMaster.UpdatedBy = userId;
tblTpLcdMaster.UpdatedDate = DateTime.Now;
result = _lcdGlueStationService.UpdateTpLcdStation(tblTpLcdMaster);
if (result.IsSuccess == true && tpLcdData.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 = tpLcdData.Code;
rework.Issue = item.Issue;
rework.FailedFrom = "TPLCD";
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));
}
