public JsonResult GetComponentsByProject(int projectId)
{
var _entity = new WCMSEntities();
var list = _entity.ProjectBomList.Where(a => a.ProjectMasterId == projectId).ToList();
var component = new List <tblComponentRequisition>();
foreach (var items in list)
{
var com = _entity.tblComponentRequisition.FirstOrDefault(x => x.ComponentId == items.ComponentId);
var tblComponentRequisition = new tblComponentRequisition();
if (com != null)
{
tblComponentRequisition.ComponentId = com.ComponentId;
tblComponentRequisition.ComponentName = com.ComponentName;
tblComponentRequisition.ReqQuantity = com.ReqQuantity - com.UsedQuantity;
}
else
{
tblComponentRequisition.ComponentId = items.ComponentId;
tblComponentRequisition.ComponentName = items.ComponentName;
tblComponentRequisition.ReqQuantity = 0;
}
component.Add(tblComponentRequisition);
}
return(Json(component, JsonRequestBehavior.AllowGet));
}
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 bool InsertComponentRequisition(tblComponentRequisition componentRequisition)
{
try
{
_entity.tblComponentRequisition.Add(componentRequisition);
_entity.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
return(true);
}
public Result InsertComponentRequisition(tblComponentRequisition componentRequisition)
{
try
{
return(_CommonManager.InsertComponentRequisition(componentRequisition));
}
catch (Exception ex)
{
//if (log.IsErrorEnabled)
//log.Error("Select Bearer: " + ex.Message);
return(new Result {
IsSuccess = false, Message = ex.Message
});
}
}
public Result InsertComponentRequisition(tblComponentRequisition componentRequisition)
{
try
{
IInsertingSetupCommon _IDataAccessInsert = new WCMS_Common_Inserting();
using (TransactionScope transaction = new TransactionScope(TransactionScopeOption.Required, ApplicationState.TransactionOptions))
{
Result _Result = new Result();
_Result.IsSuccess = _IDataAccessInsert.InsertComponentRequisition(componentRequisition);
if (_Result.IsSuccess)
{
transaction.Complete();
}
return(_Result);
}
}
catch (Exception ex) { throw ex; }
}
public JsonResult InsertComponentRequisition(List <tblComponentRequisition> componentListFinal)
{
long userId = (long)IDictionary[2].Id;
long projectId = (long)IDictionary[3].Id;
Result _Result = new Result();
tblComponentRequisition componentRequisition = new tblComponentRequisition();
if (userId != 0)
{
try
{
foreach (tblComponentRequisition items in componentListFinal)
{
componentRequisition.ComponentId = items.ComponentId;
componentRequisition.ComponentName = items.ComponentName;
componentRequisition.ReqQuantity = items.ReqQuantity;
componentRequisition.OracleReqNumber = items.OracleReqNumber;
componentRequisition.OracleReqDate = items.OracleReqDate;
componentRequisition.UsedQuantity = 0;
componentRequisition.AddedBy = userId;
componentRequisition.AddedDate = DateTime.Now;
_Result = _CommonService.InsertComponentRequisition(componentRequisition);
}
}
catch (Exception)
{
return(Json("Error"));
}
return(Json(_Result));
}
else
{
return(Json(new Result {
Id = "0"
}));
}
}
