public List <tblCkdRfMaster> GetCkdRfMasterInfo(tblCkdRfMaster tblCkdRfMaster)
{
try
{
ICKD iDataAccessSelect = new WCMS_DAL_CKD();
return(iDataAccessSelect.GetCkdRfMasterInfo(tblCkdRfMaster));
}
catch (Exception ex) { throw ex; }
}
public Result UpdateCkdRfInfo(tblCkdRfMaster rfTableTestComponent)
{
try
{
return(_ckdManage.UpdateCkdrfInfo(rfTableTestComponent));
}
catch (Exception ex)
{
return(new Result {
IsSuccess = false, Message = ex.Message
});
}
}
public Result InsertCkdRfComponentInfo(tblCkdRfMaster rfTableTestComponent)
{
try
{
//tblTest mmItabltestComponent = null;
return(_ckdManage.InsertCkdRfComponentInfo(rfTableTestComponent));
}
catch (Exception ex)
{
return(new Result {
IsSuccess = false, Message = ex.Message
});
}
}
//For RF
public bool InsertRfStationInformation(tblCkdRfMaster rfTableTestComponent)
{
try
{
_entity.tblCkdRfMaster.Add(rfTableTestComponent);
_entity.SaveChanges();
return(true);
}
catch (Exception exception)
{
throw exception;
}
}
public List <tblCkdRfMaster> GetCkdRfMasterInfo(tblCkdRfMaster tblCkdRfMaster)
{
List <tblCkdRfMaster> rfMasterList;
try
{
rfMasterList = _ckdManage.GetCkdRfMasterInfo(tblCkdRfMaster);
}
catch (Exception ex)
{
throw ex;
}
return(rfMasterList);
}
public List <tblCkdRfMaster> GetCkdRfMasterInfo(tblCkdRfMaster tblCkdRfMaster)
{
List <tblCkdRfMaster> rfList;
try
{
rfList = _entity.tblCkdRfMaster
.WhereIf(tblCkdRfMaster.ProjectId != null, x => x.ProjectId == tblCkdRfMaster.ProjectId)
.WhereIf(tblCkdRfMaster.BarCode != null, x => x.BarCode == tblCkdRfMaster.BarCode)
.AsNoTracking().ToList();
}
catch (Exception ex)
{
throw ex;
}
return(rfList);
}
public Result UpdateCkdrfInfo(tblCkdRfMaster rfTableTestComponent)
{
try
{
using (
var transaction = new TransactionScope(TransactionScopeOption.Required,
ApplicationState.TransactionOptions))
{
var result = new Result();
result.IsSuccess = _ickd.UpdateCkdRfInfo(rfTableTestComponent);
if (result.IsSuccess)
{
transaction.Complete();
}
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateCkdRfInfo(tblCkdRfMaster rfTableTestComponent)
{
_entity.Configuration.LazyLoadingEnabled = false;
var rfMaster =
_entity.tblCkdRfMaster.FirstOrDefault(x => x.BarCode == rfTableTestComponent.BarCode);
if (rfMaster != null)
{
if (rfTableTestComponent.Passed != null)
{
rfMaster.Passed = rfTableTestComponent.Passed;
}
if (rfTableTestComponent.UpdatedBy != null)
{
rfMaster.UpdatedBy = rfTableTestComponent.UpdatedBy;
}
if (rfTableTestComponent.UpdatedDate != null)
{
rfMaster.UpdatedDate = rfTableTestComponent.UpdatedDate;
}
_entity.Entry(rfMaster).State = EntityState.Modified;
_entity.SaveChanges();
}
else
{
return(false);
}
return(true);
}
//For RF
public JsonResult InsertRfStationInformation(tblCkdRfMaster rfTableTestComponent, 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.GetCkdRfMasterInfo(new tblCkdRfMaster {
BarCode = rfTableTestComponent.BarCode
})
.Any();
if (isBarCodeExists)
{
rfTableTestComponent.AddedBy = userId;
rfTableTestComponent.AddedDate = DateTime.Now;
rfTableTestComponent.UpdatedBy = userId;
rfTableTestComponent.UpdatedDate = DateTime.Now;
result = _ckdService.UpdateCkdRfInfo(rfTableTestComponent);
if (result.IsSuccess == true && rfTableTestComponent.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
{
rfTableTestComponent.LineId = lineId;
rfTableTestComponent.AddedBy = userId;
rfTableTestComponent.AddedDate = DateTime.Now;
rfTableTestComponent.UpdatedBy = userId;
rfTableTestComponent.UpdatedDate = DateTime.Now;
result = _ckdService.InsertCkdRfComponentInfo(rfTableTestComponent);
if (result.IsSuccess == true && rfTableTestComponent.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));
}
