/// <summary>
/// Get data open Breakdown
/// </summary>
/// <param name="sampleProductID"></param>
/// <param name="notification"></param>
/// <returns></returns>
public object GetDataForBreakdown(int sampleProductID, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification();
notification.Type = Library.DTO.NotificationType.Success;
DTO.FactoryBreakdownDTO data = new DTO.FactoryBreakdownDTO();
try
{
using (var context = CreateContext())
{
var dbItem = context.FactoryBreakdownMng_FactoryBreakdown_View.FirstOrDefault(o => o.SampleProductID == sampleProductID);
if (dbItem == null)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = "Can't find Factory Breakdown!";
return(data);
}
data = converter.DB2DTO_FactoryBreakdownDTO(dbItem);
}
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = Library.Helper.GetInnerException(ex).Message;
}
return(data);
}
public override bool UpdateData(int userId, int id, ref object dtoItem, out Library.DTO.Notification notification)
{
DTO.FactoryBreakdownDTO dtoBreakdown = ((Newtonsoft.Json.Linq.JObject)dtoItem).ToObject <DTO.FactoryBreakdownDTO>();
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
try
{
// check data access permission
if (dtoBreakdown.SampleProductID.HasValue)
{
if (CheckSamplePermission(userId, dtoBreakdown.SampleProductID.Value) <= 0)
{
throw new Exception("Data access not authorized!");
}
}
//else
//{
// throw new Exception("Invalid sample product data! (id null)");
//}
using (FactoryBreakdownMngEntities context = CreateContext())
{
FactoryBreakdown dbItem = null;
if (id == 0)
{
dbItem = new FactoryBreakdown();
context.FactoryBreakdown.Add(dbItem);
dbItem.UpdatedBy = userId;
dbItem.UpdatedDate = DateTime.Now;
}
else
{
dbItem = context.FactoryBreakdown.FirstOrDefault(o => o.FactoryBreakdownID == id);
}
if (dbItem == null)
{
notification.Message = "Factory breakdown not found!";
return(false);
}
else
{
dbItem.UpdatedBy = userId;
dbItem.UpdatedDate = DateTime.Now;
converter.DTO2DB_FactoryBreakdown(dtoBreakdown, ref dbItem, userId);
context.FactoryBreakdownDetail.Local.Where(o => o.FactoryBreakdown == null).ToList().ForEach(o => context.FactoryBreakdownDetail.Remove(o));
context.FactoryBreakdownModel.Local.Where(o => o.FactoryBreakdown == null).ToList().ForEach(o => context.FactoryBreakdownModel.Remove(o));
context.SaveChanges();
dtoItem = GetData(userId, dbItem.FactoryBreakdownID, dbItem.SampleProductID, dbItem.ModelID, out notification).Data;
return(true);
}
}
}
catch (Exception ex)
{
notification = new Library.DTO.Notification()
{
Message = ex.Message, Type = Library.DTO.NotificationType.Error
};
return(false);
}
}
public void DTO2DB_FactoryBreakdown(DTO.FactoryBreakdownDTO dtoItem, ref FactoryBreakdown dbItem, int userId)
{
// factory breakdown
dbItem.UpdatedBy = userId;
dbItem.UpdatedDate = DateTime.Now;
// remark image
foreach (FactoryBreakdownDetail dbDetail in dbItem.FactoryBreakdownDetail.ToArray())
{
if (!dtoItem.FactoryBreakdownDetailDTOs.Select(o => o.FactoryBreakdownDetailID).Contains(dbDetail.FactoryBreakdownDetailID))
{
dbItem.FactoryBreakdownDetail.Remove(dbDetail);
}
}
foreach (DTO.FactoryBreakdownDetailDTO dtoDetail in dtoItem.FactoryBreakdownDetailDTOs)
{
FactoryBreakdownDetail dbDetail;
if (dtoDetail.FactoryBreakdownDetailID <= 0)
{
dbDetail = new FactoryBreakdownDetail();
dbItem.FactoryBreakdownDetail.Add(dbDetail);
}
else
{
dbDetail = dbItem.FactoryBreakdownDetail.FirstOrDefault(o => o.FactoryBreakdownDetailID == dtoDetail.FactoryBreakdownDetailID);
}
if (dbDetail != null)
{
// change
AutoMapper.Mapper.Map <DTO.FactoryBreakdownDetailDTO, FactoryBreakdownDetail>(dtoDetail, dbDetail);
}
}
// remark image
foreach (FactoryBreakdownModel dbModel in dbItem.FactoryBreakdownModel.ToArray())
{
if (!dtoItem.FactoryBreakdownModels.Select(o => o.FactoryBreakdownModelID).Contains(dbModel.FactoryBreakdownModelID))
{
dbItem.FactoryBreakdownModel.Remove(dbModel);
}
}
foreach (DTO.FactoryBreakdownModelDTO dtoModel in dtoItem.FactoryBreakdownModels)
{
FactoryBreakdownModel dbModel;
if (dtoModel.FactoryBreakdownModelID <= 0)
{
dbModel = new FactoryBreakdownModel();
dbItem.FactoryBreakdownModel.Add(dbModel);
}
else
{
dbModel = dbItem.FactoryBreakdownModel.FirstOrDefault(o => o.FactoryBreakdownModelID == dtoModel.FactoryBreakdownModelID);
}
if (dbModel != null)
{
// change
AutoMapper.Mapper.Map <DTO.FactoryBreakdownModelDTO, FactoryBreakdownModel>(dtoModel, dbModel);
}
}
// change
AutoMapper.Mapper.Map <DTO.FactoryBreakdownDTO, FactoryBreakdown>(dtoItem, dbItem);
}
