public bool UpdateComponentRequisitionList(tblAssemblyLineSetupDetails tblAssemblyLineSetupDetails)
{
_entity.Configuration.LazyLoadingEnabled = false;
tblComponentRequisition componentRequisition =
_entity.tblComponentRequisition.FirstOrDefault(
x => x.ComponentId == tblAssemblyLineSetupDetails.ComponentId);
if (componentRequisition != null)
{
if (tblAssemblyLineSetupDetails != null)
{
componentRequisition.UsedQuantity = componentRequisition.UsedQuantity +
tblAssemblyLineSetupDetails.SubmitQuantity;
}
_entity.Entry(componentRequisition).State = EntityState.Modified;
_entity.SaveChanges();
}
else
{
return(false);
}
return(true);
}
public JsonResult InsertProductionLineSetup(tblAssemblyLineSetup assemblyLine, List <tblAssemblyLineSetupDetails> assemblyLineSetupDetails)
{
Dictionary <int, SessionData> IDictionary = SessionData.GetSessionValues();
var userId = (long)IDictionary[2].Id;
var result = new Result();
var tblAssemblyLineSetup = new tblAssemblyLineSetup();
try
{
tblAssemblyLineSetup.AssemblyLineId = assemblyLine.AssemblyLineId;
tblAssemblyLineSetup.ProjectId = assemblyLine.ProjectId;
tblAssemblyLineSetup.ProjectName = assemblyLine.ProjectName;
tblAssemblyLineSetup.ManPower = assemblyLine.ManPower;
tblAssemblyLineSetup.IssuedQuantity = assemblyLine.IssuedQuantity;
tblAssemblyLineSetup.HourlyTargetQuantity = assemblyLine.HourlyTargetQuantity;
tblAssemblyLineSetup.TotalTargetQuantity = assemblyLine.TotalTargetQuantity;
tblAssemblyLineSetup.AddedBy = (int)userId;
tblAssemblyLineSetup.AddedDate = DateTime.Now;
result = _adminService.InsertProductionLineSetup(tblAssemblyLineSetup);
if (result.IsSuccess)
{
var tblAssemblyLineSetupDetails = new tblAssemblyLineSetupDetails();
foreach (var items in assemblyLineSetupDetails)
{
tblAssemblyLineSetupDetails.LineId = assemblyLine.AssemblyLineId;
tblAssemblyLineSetupDetails.ProjectId = items.ProjectId;
tblAssemblyLineSetupDetails.ComponentId = items.ComponentId;
tblAssemblyLineSetupDetails.ComponentName = items.ComponentName;
tblAssemblyLineSetupDetails.RequisitionQuantity = items.RequisitionQuantity;
tblAssemblyLineSetupDetails.SubmitQuantity = items.SubmitQuantity;
tblAssemblyLineSetupDetails.AddedBy = (int)userId;
tblAssemblyLineSetupDetails.AddedDate = DateTime.Now;
result = _adminService.InsertProductionLineSetupDetails(tblAssemblyLineSetupDetails);
if (result.IsSuccess)
{
result = _commonService.UpdateComponentRequisitionList(tblAssemblyLineSetupDetails);
}
}
}
}
catch (Exception)
{
throw;
}
return(Json(result));
}
public bool InsertProductionLineSetupDetails(tblAssemblyLineSetupDetails tblAssemblyLineSetupDetails)
{
try
{
_entity.tblAssemblyLineSetupDetails.Add(tblAssemblyLineSetupDetails);
_entity.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
return(true);
}
public Result InsertProductionLineSetupDetails(tblAssemblyLineSetupDetails tblAssemblyLineSetupDetails)
{
try
{
return(adminManager.InsertProductionLineSetupDetails(tblAssemblyLineSetupDetails));
}
catch (Exception ex)
{
return(new Result {
IsSuccess = false, Message = ex.Message
});
}
}
public Result UpdateComponentRequisitionList(tblAssemblyLineSetupDetails tblAssemblyLineSetupDetails)
{
try
{
return(_CommonManager.UpdateComponentRequisitionList(tblAssemblyLineSetupDetails));
}
catch (Exception ex)
{
//if (log.IsErrorEnabled)
//log.Error("Select Bearer: " + ex.Message);
return(new Result {
IsSuccess = false, Message = ex.Message
});
}
}
public Result UpdateComponentRequisitionList(tblAssemblyLineSetupDetails tblAssemblyLineSetupDetails)
{
try
{
IInsertingSetupCommon _IDataAccessInsert = new WCMS_Common_Inserting();
using (TransactionScope transaction = new TransactionScope(TransactionScopeOption.Required, ApplicationState.TransactionOptions))
{
Result _Result = new Result();
_Result.IsSuccess = _IDataAccessInsert.UpdateComponentRequisitionList(tblAssemblyLineSetupDetails);
if (_Result.IsSuccess)
{
transaction.Complete();
}
return(_Result);
}
}
catch (Exception ex) { throw ex; }
}
public Result InsertProductionLineSetupDetails(tblAssemblyLineSetupDetails tblAssemblyLineSetupDetails)
{
try
{
IAdmin iAdmin = new WCMS_DAL_Admin();
using (TransactionScope transaction = new TransactionScope(TransactionScopeOption.Required, ApplicationState.TransactionOptions))
{
Result _Result = new Result();
_Result.IsSuccess = iAdmin.InsertProductionLineSetupDetails(tblAssemblyLineSetupDetails);
if (_Result.IsSuccess)
{
transaction.Complete();
}
return(_Result);
}
}
catch (Exception ex) { throw ex; }
}
