public List <tblCkdSmtMaster> GetAnyParaMeterInfo(tblCkdSmtMaster tblCkdSmtMaster)
{
try
{
ICKD iDataAccessSelect = new WCMS_DAL_CKD();
return(iDataAccessSelect.GetAnyParaMeterInfo(tblCkdSmtMaster));
}
catch (Exception ex) { throw ex; }
}
public Result UpdateCkdSmtInfo(tblCkdSmtMaster smtTableTestComponent)
{
try
{
return(_ckdManage.UpdateCkdSmtInfo(smtTableTestComponent));
}
catch (Exception ex)
{
return(new Result {
IsSuccess = false, Message = ex.Message
});
}
}
public Result InsertCkdSmtComponentInfo(tblCkdSmtMaster smtTableTestComponent)
{
try
{
//tblTest mmItabltestComponent = null;
return(_ckdManage.InsertCkdSmtComponentInfo(smtTableTestComponent));
}
catch (Exception ex)
{
return(new Result {
IsSuccess = false, Message = ex.Message
});
}
}
//For SMT
public bool InsertCkdSmtComponentInfo(tblCkdSmtMaster smtTableTestComponent)
{
try
{
_entity.tblCkdSmtMaster.Add(smtTableTestComponent);
_entity.SaveChanges();
return(true);
}
catch (Exception exception)
{
throw exception;
}
}
public List <tblCkdSmtMaster> GetCkdSmtMasterInfo(tblCkdSmtMaster tblCkdSmtMaster)
{
List <tblCkdSmtMaster> smtMasterList;
try
{
smtMasterList = _ckdManage.GetCkdSmtMasterInfo(tblCkdSmtMaster);
}
catch (Exception ex)
{
throw ex;
}
return(smtMasterList);
}
public List <tblCkdSmtMaster> GetCkdSmtMasterInfo(tblCkdSmtMaster tblCkdSmtMaster)
{
List <tblCkdSmtMaster> smtList;
try
{
smtList = _entity.tblCkdSmtMaster
.WhereIf(tblCkdSmtMaster.ProjectId != null, x => x.ProjectId == tblCkdSmtMaster.ProjectId)
.WhereIf(tblCkdSmtMaster.BarCode != null, x => x.BarCode == tblCkdSmtMaster.BarCode)
.AsNoTracking().ToList();
}
catch (Exception ex)
{
throw ex;
}
return(smtList);
}
public Result InsertCkdSmtComponentInfo(tblCkdSmtMaster smtTableTestComponent)
{
try
{
using (
var transaction = new TransactionScope(TransactionScopeOption.Required,
ApplicationState.TransactionOptions))
{
var result = new Result();
result.IsSuccess = _ickd.InsertCkdSmtComponentInfo(smtTableTestComponent);
if (result.IsSuccess)
{
transaction.Complete();
}
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateCkdSmtInfo(tblCkdSmtMaster smtTableTestComponent)
{
_entity.Configuration.LazyLoadingEnabled = false;
var smtMaster =
_entity.tblCkdSmtMaster.FirstOrDefault(x => x.BarCode == smtTableTestComponent.BarCode);
if (smtMaster != null)
{
if (smtTableTestComponent.Passed != null)
{
smtMaster.Passed = smtTableTestComponent.Passed;
}
if (smtTableTestComponent.UpdatedBy != null)
{
smtMaster.UpdatedBy = smtTableTestComponent.UpdatedBy;
}
if (smtTableTestComponent.UpdatedDate != null)
{
smtMaster.UpdatedDate = smtTableTestComponent.UpdatedDate;
}
_entity.Entry(smtMaster).State = EntityState.Modified;
_entity.SaveChanges();
}
else
{
return(false);
}
return(true);
}
public JsonResult InsertSmtStationInformation(tblCkdSmtMaster smtTableTestComponent, 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.GetCkdSmtMasterInfo(new tblCkdSmtMaster {
BarCode = smtTableTestComponent.BarCode
})
.Any();
if (isBarCodeExists)
{
smtTableTestComponent.AddedBy = userId;
smtTableTestComponent.AddedDate = DateTime.Now;
smtTableTestComponent.UpdatedBy = userId;
smtTableTestComponent.UpdatedDate = DateTime.Now;
result = _ckdService.UpdateCkdSmtInfo(smtTableTestComponent);
if (result.IsSuccess == true && smtTableTestComponent.Passed.ToUpper() == "N")
{
var Reresult = new Result();
var rework = new tblCkdRework();
foreach (tblCkdRework item in reworkList)
{
rework.LineId = lineId;
rework.ProjectId = 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
{
smtTableTestComponent.LineId = lineId;
smtTableTestComponent.AddedBy = userId;
smtTableTestComponent.AddedDate = DateTime.Now;
smtTableTestComponent.UpdatedBy = userId;
smtTableTestComponent.UpdatedDate = DateTime.Now;
result = _ckdService.InsertCkdSmtComponentInfo(smtTableTestComponent);
if (result.IsSuccess == true && smtTableTestComponent.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));
}
