public List <tblDailyIssuedComponents> GetPCBInfo(tblDailyIssuedComponents tblDailyIssuedComponents)
{
try
{
ISelectingCommon iDataAccessSelect = new DALGetCommonSelecting();
return(iDataAccessSelect.GetPCBInfo(tblDailyIssuedComponents));
}
catch (Exception ex) { throw ex; }
}
public List <tblDailyIssuedComponents> GetPCBInfo(tblDailyIssuedComponents tblDailyIssuedComponents)
{
var list = new List <tblDailyIssuedComponents>();
try
{
list = _CommonManager.GetPCBInfo(tblDailyIssuedComponents);
}
catch (Exception ex)
{
}
return(list);
}
public Result InsertIssuedComponents(tblDailyIssuedComponents issuedComponents)
{
try
{
return(_CommonManager.InsertIssuedComponents(issuedComponents));
}
catch (Exception ex)
{
return(new Result {
IsSuccess = false, Message = ex.Message
});
}
}
public bool InsertIssuedComponents(tblDailyIssuedComponents issuedComponents)
{
try
{
_entity.tblDailyIssuedComponents.Add(issuedComponents);
_entity.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
return(true);
}
public List <tblDailyIssuedComponents> GetPCBInfo(tblDailyIssuedComponents tblDailyIssuedComponents)
{
List <tblDailyIssuedComponents> list;
try
{
list = _wcmsEntities.tblDailyIssuedComponents
.WhereIf(tblDailyIssuedComponents.ComponentCode != null, x => x.ComponentCode == tblDailyIssuedComponents.ComponentCode)
.WhereIf(tblDailyIssuedComponents.ProjectId != null, x => x.ProjectId == tblDailyIssuedComponents.ProjectId)
.AsNoTracking().ToList();
}
catch (Exception)
{
throw;
}
return(list);
}
public Result InsertIssuedComponents(tblDailyIssuedComponents issuedComponents)
{
try
{
IInsertingSetupCommon _IDataAccessInsert = new WCMS_Common_Inserting();
using (var transaction = new TransactionScope(TransactionScopeOption.Required, ApplicationState.TransactionOptions))
{
var result = new Result();
issuedComponents.AddedDate = DateTime.Now;
result.IsSuccess = _IDataAccessInsert.InsertIssuedComponents(issuedComponents);
if (result.IsSuccess)
{
transaction.Complete();
}
return(result);
}
}
catch (Exception ex) { throw ex; }
}
public JsonResult InsertIssuedComponents(tblDailyIssuedComponents issuedComponents)
{
long userId = (long)IDictionary[2].Id;
long projectId = (long)IDictionary[3].Id;
long lineId = (long)IDictionary[4].Id;
DateTime startDate = DateTime.Today;
DateTime endDate = startDate.AddDays(1).AddTicks(-1);
var result = new Result();
if (userId != 0 && lineId != 0 && projectId != 0)//&& lineId != 0 && projectId != 0
{
try
{
var isComponentExists =
_CommonService.GetPCBInfo(new tblDailyIssuedComponents()
{
ComponentCode = (issuedComponents.ComponentCode).Trim()
}).FirstOrDefault();
if (isComponentExists == null)
{
issuedComponents.ProjectName = _CommonService.GetAssemblineInfo(new tblAssemblyLineSetup()
{
ProjectId = Convert.ToInt32(projectId)
}).Where(a => a.AddedDate >= startDate && a.AddedDate <= endDate).Select(x => x.ProjectName).FirstOrDefault();
issuedComponents.ComponentName = issuedComponents.ComponentName;
issuedComponents.LineId = lineId;
issuedComponents.ComponentCode = issuedComponents.ComponentCode.Trim();
issuedComponents.ProjectId = projectId;
issuedComponents.AddedBy = userId;
result = _CommonService.InsertIssuedComponents(issuedComponents);
if (result.IsSuccess)
{
// var objstate = componentsCount.Select(x => new { pendingListCount = componentsCount.Count,message="Added Successfully" }).ToList();
return(Json(result));
}
}
else
{
result.Message = "Duplicate PCB Code !";
return(Json(result));
}
}
catch (Exception exception)
{
throw;
}
}
else
{
return(Json(new Result {
Id = "0"
}));
// return Json(new Result {Message = "Error Occured Please Logout and Login Again !"});
}
return(Json(result));
}
