public List <tblCkdSoftwareLoadMaster> GetCkdSoftwareLoadMasterInfo(tblCkdSoftwareLoadMaster tblCkdSoftwareLoadMaster)
{
try
{
ICKD iDataAccessSelect = new WCMS_DAL_CKD();
return(iDataAccessSelect.GetCkdSoftwareLoadMasterInfo(tblCkdSoftwareLoadMaster));
}
catch (Exception ex) { throw ex; }
}
public Result UpdateCkdSoftwareLoadInfo(tblCkdSoftwareLoadMaster softwareLoadTableTestComponent)
{
try
{
return(_ckdManage.UpdateCkdSoftwareLoadInfo(softwareLoadTableTestComponent));
}
catch (Exception ex)
{
return(new Result {
IsSuccess = false, Message = ex.Message
});
}
}
//SoftwareLoad
public Result InsertCkdSoftwareLoadComponentInfo(tblCkdSoftwareLoadMaster softwareLoadTableTestComponent)
{
try
{
//tblTest mmItabltestComponent = null;
return(_ckdManage.InsertCkdSoftwareLoadComponentInfo(softwareLoadTableTestComponent));
}
catch (Exception ex)
{
return(new Result {
IsSuccess = false, Message = ex.Message
});
}
}
//For Software Load
public bool InsertSoftwareLoadStationInformation(tblCkdSoftwareLoadMaster softwareLoadTableTestComponent)
{
try
{
_entity.tblCkdSoftwareLoadMaster.Add(softwareLoadTableTestComponent);
_entity.SaveChanges();
return(true);
}
catch (Exception exception)
{
throw exception;
}
}
public List <tblCkdSoftwareLoadMaster> GetCkdSoftwareLoadMasterInfo(tblCkdSoftwareLoadMaster tblCkdSoftwareLoadMaster)
{
List <tblCkdSoftwareLoadMaster> softwareLoadMasterList;
try
{
softwareLoadMasterList = _ckdManage.GetCkdSoftwareLoadMasterInfo(tblCkdSoftwareLoadMaster);
}
catch (Exception ex)
{
throw ex;
}
return(softwareLoadMasterList);
}
public List <tblCkdSoftwareLoadMaster> GetCkdSoftwareLoadMasterInfo(tblCkdSoftwareLoadMaster tblCkdSoftwareLoadMaster)
{
List <tblCkdSoftwareLoadMaster> softwareLoadList;
try
{
softwareLoadList = _entity.tblCkdSoftwareLoadMaster
.WhereIf(tblCkdSoftwareLoadMaster.ProjectId != null, x => x.ProjectId == tblCkdSoftwareLoadMaster.ProjectId)
.WhereIf(tblCkdSoftwareLoadMaster.BarCode != null, x => x.BarCode == tblCkdSoftwareLoadMaster.BarCode)
.AsNoTracking().ToList();
}
catch (Exception ex)
{
throw ex;
}
return(softwareLoadList);
}
public Result UpdateCkdSoftwareLoadInfo(tblCkdSoftwareLoadMaster softwareLoadTableTestComponent)
{
try
{
using (
var transaction = new TransactionScope(TransactionScopeOption.Required,
ApplicationState.TransactionOptions))
{
var result = new Result();
result.IsSuccess = _ickd.UpdateCkdSoftwareLoadInfo(softwareLoadTableTestComponent);
if (result.IsSuccess)
{
transaction.Complete();
}
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateCkdSoftwareLoadInfo(tblCkdSoftwareLoadMaster softwareLoadTableTestComponent)
{
_entity.Configuration.LazyLoadingEnabled = false;
var softwareLoadMaster =
_entity.tblCkdSoftwareLoadMaster.FirstOrDefault(x => x.BarCode == softwareLoadTableTestComponent.BarCode);
if (softwareLoadMaster != null)
{
if (softwareLoadTableTestComponent.Passed != null)
{
softwareLoadMaster.Passed = softwareLoadTableTestComponent.Passed;
}
if (softwareLoadTableTestComponent.UpdatedBy != null)
{
softwareLoadMaster.UpdatedBy = softwareLoadTableTestComponent.UpdatedBy;
}
if (softwareLoadTableTestComponent.UpdatedDate != null)
{
softwareLoadMaster.UpdatedDate = softwareLoadTableTestComponent.UpdatedDate;
}
_entity.Entry(softwareLoadMaster).State = EntityState.Modified;
_entity.SaveChanges();
}
else
{
return(false);
}
return(true);
}
//For Software Load
public JsonResult InsertSoftwareLoadStationInformation(tblCkdSoftwareLoadMaster softwareLoadTableTestComponent, List <tblCkdRework> reworkList)
{
WCMSEntities entities = new WCMSEntities();
var startDate = DateTime.Today;
var endDate = startDate.AddDays(1).AddTicks(-1);
var userId = (long)_dictionary[2].Id;
var projectId = (long)_dictionary[3].Id;
long lineId = (long)_dictionary[4].Id;
var result = new Result();
try
{
var isBarCodeExists =
_ckdService.GetCkdSoftwareLoadMasterInfo(new tblCkdSoftwareLoadMaster {
BarCode = softwareLoadTableTestComponent.BarCode
})
.Any();
if (isBarCodeExists)
{
softwareLoadTableTestComponent.AddedBy = userId;
softwareLoadTableTestComponent.AddedDate = DateTime.Now;
softwareLoadTableTestComponent.UpdatedBy = userId;
softwareLoadTableTestComponent.UpdatedDate = DateTime.Now;
result = _ckdService.UpdateCkdSoftwareLoadInfo(softwareLoadTableTestComponent);
if (result.IsSuccess == true && softwareLoadTableTestComponent.Passed.ToUpper() == "N")
{
var Reresult = new Result();
var rework = new tblCkdRework();
foreach (tblCkdRework item in reworkList)
{
rework.LineId = lineId;
rework.ProjectId = userId; //projectId;
rework.BarCode = item.BarCode;
rework.Issues = item.Issues;
rework.FailedStation = item.FailedStation;
rework.Type = item.Type;
rework.Model = item.Model;
rework.LotNumber = item.LotNumber;
rework.Supplier = item.Supplier;
rework.Code = item.Code;
rework.Status = "P";
rework.AddedBy = userId;
rework.AddedDate = DateTime.Now;
Reresult = _ckdService.InsertCkdRework(rework);
}
}
}
else
{
softwareLoadTableTestComponent.LineId = lineId;
softwareLoadTableTestComponent.AddedBy = userId;
softwareLoadTableTestComponent.AddedDate = DateTime.Now;
softwareLoadTableTestComponent.UpdatedBy = userId;
softwareLoadTableTestComponent.UpdatedDate = DateTime.Now;
result = _ckdService.InsertCkdSoftwareLoadComponentInfo(softwareLoadTableTestComponent);
if (result.IsSuccess == true && softwareLoadTableTestComponent.Passed.ToUpper() == "N")
{
var Reresult = new Result();
tblCkdRework rework = new tblCkdRework();
foreach (tblCkdRework item in reworkList)
{
rework.LineId = lineId;
rework.ProjectId = userId; //projectId;
rework.BarCode = item.BarCode;
rework.Issues = item.Issues;
rework.FailedStation = item.FailedStation;
rework.Type = item.Type;
rework.Model = item.Model;
rework.LotNumber = item.LotNumber;
rework.Supplier = item.Supplier;
rework.Code = item.Code;
rework.Status = "P";
rework.AddedBy = userId;
rework.AddedDate = DateTime.Now;
Reresult = _ckdService.InsertCkdRework(rework);
}
}
}
}
catch (Exception ex)
{
result.Message = ex.ToString();
//throw ex;
}
return(Json(result));
}
