public List <tblScrew> GetScrewStationInfo(tblScrew tblScrew)
{
try
{
ISelectingCommon iDataAccessSelect = new DALGetCommonSelecting();
return(iDataAccessSelect.GetScrewStationInfo(tblScrew));
}
catch (Exception ex) { throw ex; }
}
public List <tblScrew> GetScrewStationInfo(tblScrew tblScrew)
{
var list = new List <tblScrew>();
try
{
list = _CommonManager.GetScrewStationInfo(tblScrew);
}
catch (Exception ex)
{
}
return(list);
}
public Result InsertScrewStationInfo(tblScrew screw)
{
try
{
return(_CommonManager.InsertScrewStationInfo(screw));
}
catch (Exception ex)
{
return(new Result {
IsSuccess = false, Message = ex.Message
});
}
}
public bool InsertScrewStationInfo(tblScrew screw)
{
try
{
_entity.tblScrew.Add(screw);
_entity.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
return(true);
}
public List <tblScrew> GetScrewStationInfo(tblScrew tblScrew)
{
List <tblScrew> list;
try
{
list = _wcmsEntities.tblScrew
.WhereIf(tblScrew.MobileCode != null, x => x.MobileCode == tblScrew.MobileCode)
.WhereIf(tblScrew.ProjectId != null, x => x.ProjectId == tblScrew.ProjectId)
.AsNoTracking().ToList();
}
catch (Exception)
{
throw;
}
return(list);
}
public Result InsertScrewStationInfo(tblScrew screw)
{
try
{
IInsertingSetupCommon _IDataAccessInsert = new WCMS_Common_Inserting();
using (var transaction = new TransactionScope(TransactionScopeOption.Required, ApplicationState.TransactionOptions))
{
var result = new Result();
result.IsSuccess = _IDataAccessInsert.InsertScrewStationInfo(screw);
if (result.IsSuccess)
{
transaction.Complete();
}
return(result);
}
}
catch (Exception ex) { throw ex; }
}
public JsonResult InsertScrewStationInfo(tblScrew screw)
{
var result = new Result();
var startDate = DateTime.Today;
var endDate = startDate.AddDays(1).AddTicks(-1);
long userId = (long)IDictionary[2].Id;
long projectId = (long)IDictionary[3].Id;
long lineId = (long)IDictionary[4].Id;
if (userId != 0 && lineId != 0)//&& lineId!=0
{
var pcbStation = _CommonService.GetPCBInfo(new tblDailyIssuedComponents()
{
ComponentCode = screw.MobileCode.Trim()
}).FirstOrDefault();
var isExists = _CommonService.GetScrewStationInfo(new tblScrew()
{
MobileCode = screw.MobileCode.Trim()
}).FirstOrDefault();
if (isExists == null)
{
if (pcbStation != null)
{
screw.LineId = lineId;
screw.ProjectName = pcbStation.ProjectName; // _CommonService.GetAssemblineInfo(new tblAssemblyLineSetup() { ProjectId = (int?)pcbStation.ProjectId }).Where(a => a.AddedDate >= startDate && a.AddedDate <= endDate).Select(x => x.ProjectName).FirstOrDefault();
screw.MobileCode = screw.MobileCode.Trim();
screw.ProjectId = pcbStation.ProjectId; //projectId;
screw.AddedBy = userId;
screw.AddedDate = DateTime.Now;
result = _CommonService.InsertScrewStationInfo(screw);
if (result.IsSuccess)
{
return(Json(result));
}
}
else
{
result.Message = "Not Scanned At PCB Station!!";
return(Json(result));
}
}
else
{
result.Message = "Duplicate Bar Code Number!!";
return(Json(result));
}
}
else
{
return(Json(new Result {
Id = "0"
}));
}
return(Json(result));
}
