public List <tblCkdMmiMaster> GetCkdMmiMasterInfo(tblCkdMmiMaster tblCkdMmiMaster)
{
try
{
ICKD iDataAccessSelect = new WCMS_DAL_CKD();
return(iDataAccessSelect.GetCkdMmiMasterInfo(tblCkdMmiMaster));
}
catch (Exception ex) { throw ex; }
}
public Result UpdateCkdMmiInfo(tblCkdMmiMaster mmItabltestComponent)
{
try
{
return(_ckdManage.UpdateCkdMmiInfo(mmItabltestComponent));
}
catch (Exception ex)
{
return(new Result {
IsSuccess = false, Message = ex.Message
});
}
}
public Result InsertCkdMmiComponentInfo(tblCkdMmiMaster mmItabltestComponent)
{
try
{
//tblTest mmItabltestComponent = null;
return(_ckdManage.InsertCkdMmiComponentInfo(mmItabltestComponent));
}
catch (Exception ex)
{
return(new Result {
IsSuccess = false, Message = ex.Message
});
}
}
//For MMI
public bool InsertCkdMmiComponentInfo(tblCkdMmiMaster mmItabltestComponent)
{
try
{
_entity.tblCkdMmiMaster.Add(mmItabltestComponent);
_entity.SaveChanges();
return(true);
}
catch (Exception exception)
{
throw exception;
}
}
public List <tblCkdMmiMaster> GetCkdMmiMasterInfo(tblCkdMmiMaster tblCkdMmiMaster)
{
List <tblCkdMmiMaster> mmiMasterList;
try
{
mmiMasterList = _ckdManage.GetCkdMmiMasterInfo(tblCkdMmiMaster);
}
catch (Exception ex)
{
throw ex;
}
return(mmiMasterList);
}
public List <tblCkdMmiMaster> GetCkdMmiMasterInfo(tblCkdMmiMaster tblCkdMmiMaster)
{
List <tblCkdMmiMaster> mmiList;
try
{
mmiList = _entity.tblCkdMmiMaster
.WhereIf(tblCkdMmiMaster.ProjectId != null, x => x.ProjectId == tblCkdMmiMaster.ProjectId)
.WhereIf(tblCkdMmiMaster.BarCode != null, x => x.BarCode == tblCkdMmiMaster.BarCode)
.AsNoTracking().ToList();
}
catch (Exception ex)
{
throw ex;
}
return(mmiList);
}
public Result UpdateCkdMmiInfo(tblCkdMmiMaster mmItabltestComponent)
{
try
{
using (
var transaction = new TransactionScope(TransactionScopeOption.Required,
ApplicationState.TransactionOptions))
{
var result = new Result();
result.IsSuccess = _ickd.UpdateCkdMmiInfo(mmItabltestComponent);
if (result.IsSuccess)
{
transaction.Complete();
}
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateCkdMmiInfo(tblCkdMmiMaster mmItabltestComponent)
{
_entity.Configuration.LazyLoadingEnabled = false;
var mmiMaster =
_entity.tblCkdMmiMaster.FirstOrDefault(x => x.BarCode == mmItabltestComponent.BarCode);
if (mmiMaster != null)
{
if (mmItabltestComponent.Passed != null)
{
mmiMaster.Passed = mmItabltestComponent.Passed;
}
if (mmItabltestComponent.UpdatedBy != null)
{
mmiMaster.UpdatedBy = mmItabltestComponent.UpdatedBy;
}
if (mmItabltestComponent.UpdatedDate != null)
{
mmiMaster.UpdatedDate = mmItabltestComponent.UpdatedDate;
}
_entity.Entry(mmiMaster).State = EntityState.Modified;
_entity.SaveChanges();
}
else
{
return(false);
}
return(true);
}
public JsonResult InsertCkdMmiStationInformation(tblCkdMmiMaster mmItabltestComponent, 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.GetCkdMmiMasterInfo(new tblCkdMmiMaster {
BarCode = mmItabltestComponent.BarCode
})
.Any();
if (isBarCodeExists)
{
mmItabltestComponent.AddedBy = userId;
mmItabltestComponent.AddedDate = DateTime.Now;
mmItabltestComponent.UpdatedBy = userId;
mmItabltestComponent.UpdatedDate = DateTime.Now;
result = _ckdService.UpdateCkdMmiInfo(mmItabltestComponent);
if (result.IsSuccess == true && mmItabltestComponent.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
{
mmItabltestComponent.LineId = lineId;
mmItabltestComponent.AddedBy = userId;
mmItabltestComponent.AddedDate = DateTime.Now;
mmItabltestComponent.UpdatedBy = userId;
mmItabltestComponent.UpdatedDate = DateTime.Now;
result = _ckdService.InsertCkdMmiComponentInfo(mmItabltestComponent);
if (result.IsSuccess == true && mmItabltestComponent.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)
{
//throw ex;
result.Message = ex.ToString();
}
return(Json(result));
}
