public Result InsertLcdGlueWorkingModels(tblLcdGlueWorkingModels workingModel)
{
try
{
return(_lcdGlueStationManager.InsertLcdGlueWorkingModels(workingModel));
}
catch (Exception ex)
{
return(new Result {
IsSuccess = false, Message = ex.Message
});
}
}
public bool InsertLcdGlueWorkingModels(tblLcdGlueWorkingModels workingModel)
{
try
{
_entity.tblLcdGlueWorkingModels.Add(workingModel);
_entity.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
return(true);
}
public Result UpdateGlueWorkingModels(tblLcdGlueWorkingModels workingModel)
{
var result = new Result();
try
{
result.IsSuccess = _iLcdGlueStation.UpdateGlueWorkingModels(workingModel);
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public Result UpdateGlueWorkingModels(tblLcdGlueWorkingModels workingModel)
{
try
{
return(_lcdGlueStationManager.UpdateGlueWorkingModels(workingModel));
}
catch (Exception ex)
{
//if (log.IsErrorEnabled)
// log.Error("Insert Sales Order : " + ex.Message);
return(new Result {
IsSuccess = false, Message = ex.Message
});
}
}
public bool UpdateGlueWorkingModels(tblLcdGlueWorkingModels workingModel)
{
try
{
_entity.Configuration.LazyLoadingEnabled = false;
var startDate = DateTime.Today;
var endDate = startDate.AddDays(1).AddTicks(-1);
//if( workingModel.Id!=null)
var wModel = _entity.tblLcdGlueWorkingModels.Where(x => x.AddedBy == workingModel.AddedBy && (x.AddedDate >= startDate && x.AddedDate <= endDate)).ToList();
if (wModel.Count > 0)
{
foreach (var items in wModel)
{
var workModels = _entity.tblLcdGlueWorkingModels.FirstOrDefault(x => x.AddedBy == items.AddedBy && (x.AddedDate >= startDate && x.AddedDate <= endDate) && x.ProjectName == items.ProjectName && x.ProjectId == items.ProjectId);
if (workModels == null)
{
continue;
}
workModels.CurentlyRunning = workModels.Id == workingModel.Id ? "Y" : "N";
_entity.Entry(workModels).State = EntityState.Modified;
_entity.SaveChanges();
}
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult UpdateProject(long projectId)
{
var userId = (long)_dictionary[2].Id;
try
{
var workingModel = new tblLcdGlueWorkingModels();
workingModel.Id = projectId;
workingModel.AddedBy = userId;
var updateResult = _lcdGlueStationService.UpdateGlueWorkingModels(workingModel);
return(Json(updateResult, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult AddWorkingProject(tblLcdGlueWorkingModels workingModels)
{
var userId = (long)_dictionary[2].Id;
var projectId = (long)_dictionary[3].Id;
var workingModel = new tblLcdGlueWorkingModels();
workingModel.ProjectId = workingModels.ProjectId;
workingModel.ProjectName = workingModels.ProjectName;
workingModel.Station = workingModels.Station;
workingModel.AddedBy = userId;
workingModel.AddedDate = DateTime.Now;
var result = _lcdGlueStationService.InsertLcdGlueWorkingModels(workingModel);
if (result.IsSuccess)
{
var updateResult = _lcdGlueStationService.UpdateGlueWorkingModels(workingModel);
}
return(Json(result));
}
public Result InsertLcdGlueWorkingModels(tblLcdGlueWorkingModels workingModel)
{
try
{
using (
var transaction = new TransactionScope(TransactionScopeOption.Required,
ApplicationState.TransactionOptions))
{
var result = new Result {
IsSuccess = _iLcdGlueStation.InsertLcdGlueWorkingModels(workingModel)
};
if (result.IsSuccess)
{
transaction.Complete();
}
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
