public DTO.InitForm GetInitData(int userId, out Library.DTO.Notification notification)
{
DTO.InitForm initData = new DTO.InitForm();
Support.DAL.DataFactory supportFactory = new Support.DAL.DataFactory();
Framework.DAL.DataFactory frameworkFactory = new Framework.DAL.DataFactory();
notification = new Library.DTO.Notification();
notification.Type = Library.DTO.NotificationType.Success;
try
{
initData.WorkCenters = supportFactory.GetWorkCenter();
int?companyID = frameworkFactory.GetCompanyID(userId);
initData.ProductionTeams = supportFactory.GetProductionTeam(companyID);
initData.FactoryWarehouses = supportFactory.GetFactoryWarehouse(companyID);
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
}
return(initData);
}
public DTO.ReportData GetProductionSchedule(int userId, Hashtable filters, out Notification notification)
{
DTO.ReportData data = new DTO.ReportData();
notification = new Library.DTO.Notification {
Type = Library.DTO.NotificationType.Success
};
try
{
int? workOrderID = null;
string workOrderUD = null;
int? workCenterID = null;;
int? productionTeamID = null;
if (filters["workOrderID"] != null)
{
workOrderID = Convert.ToInt32(filters["workOrderID"]);
}
if (filters["workOrderUD"] != null)
{
workOrderUD = filters["workOrderUD"].ToString();
}
if (filters["workCenterID"] != null)
{
workCenterID = Convert.ToInt32(filters["workCenterID"]);
}
if (filters["productionTeamID"] != null)
{
productionTeamID = Convert.ToInt32(filters["productionTeamID"]);
}
Module.Support.DAL.DataFactory support_factory = new Support.DAL.DataFactory();
Module.Framework.DAL.DataFactory fw_factory = new Framework.DAL.DataFactory();
int?companyID = fw_factory.GetCompanyID(userId);
data.WorkCenters = support_factory.GetWorkCenter();
data.ProductionTeams = support_factory.GetProductionTeam(companyID);
data.FactoryWarehouseDtos = support_factory.GetFactoryWarehouse(companyID);
using (ProductionScheduleRptEntities context = CreateContext())
{
var x = context.ProductionScheduleRpt_ProductionSchedule_View.Where(o => o.WorkOrderUD.Contains(workOrderUD == null || workOrderUD == "" ? o.WorkOrderUD : workOrderUD) &&
o.WorkCenterID == (workCenterID.HasValue ? workCenterID.Value : o.WorkCenterID) &&
o.ProductionTeamID == (productionTeamID.HasValue ? productionTeamID.Value : o.ProductionTeamID)
);
data.ProductionSchedules = converter.DB2DTO_ProductionSchedule(x.ToList());
return(data);
}
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
notification.DetailMessage.Add(ex.Message);
if (ex.GetBaseException() != null)
{
notification.DetailMessage.Add(ex.GetBaseException().Message);
}
return(new DTO.ReportData());
}
}
public DTO.InitForm GetInitData(int iRequesterID, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification();
notification.Type = Library.DTO.NotificationType.Success;
DTO.InitForm initForm = new DTO.InitForm();
initForm.FactoryWarehouses = new List <Support.DTO.FactoryWarehouseDto>();
try
{
Framework.DAL.DataFactory fwFactory = new Framework.DAL.DataFactory();
int?companyID = fwFactory.GetCompanyID(iRequesterID);
Support.DAL.DataFactory supportFactory = new Support.DAL.DataFactory();
initForm.FactoryWarehouses = supportFactory.GetFactoryWarehouse(companyID);
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
if (ex.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.Message.Trim()))
{
notification.DetailMessage.Add(ex.InnerException.Message);
}
}
return(initForm);
}
public DTO.InitDataDefaultPricePurchase GetInitDataDefaultPrice(int userID, out Notification notification)
{
notification = new Notification();
notification.Type = NotificationType.Success;
DTO.InitDataDefaultPricePurchase data = new DTO.InitDataDefaultPricePurchase();
data.SubSuppliers = new List <DTO.SupportFactoryRawMaterialDTO>();
data.FactoryWarehouses = new List <Support.DTO.FactoryWarehouseDto>();
data.StatusDefaults = new List <Support.DTO.YesNo>();
try
{
int?companyID = fwFactory.GetCompanyID(userID);
data.FactoryWarehouses = supportFactory.GetFactoryWarehouse(companyID);
data.StatusDefaults = supportFactory.GetYesNo();
using (var context = CreatContext())
{
data.SubSuppliers = converter.DB2DTO_GetFactoryRawMaterial(context.PurchaseQoutationMng_GetFactoryRawMaterial_View.ToList());
}
}
catch (Exception ex)
{
notification.Type = NotificationType.Error;
notification.Message = Library.Helper.GetInnerException(ex).Message;
}
return(data);
}
public DTO.EditFormData GetData(int userId, int id, out Library.DTO.Notification notification)
{
DTO.EditFormData editFormData = new DTO.EditFormData();
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
try
{
//get companyID
Module.Framework.DAL.DataFactory fw_factory = new Framework.DAL.DataFactory();
int?companyID = fw_factory.GetCompanyID(userId);
using (WarehouseTransferMngEntities context = CreateContext())
{
if (id > 0)
{
WarehouseTransferMng_WarehouseTransfer_View dbItem;
dbItem = context.WarehouseTransferMng_WarehouseTransfer_View.FirstOrDefault(o => o.WarehouseTransferID == id);
editFormData.Data = converter.DB2DTO_WarehouseTransfer(dbItem);
editFormData.Data.WarehouseTransferProductDTOs = new List <DTO.WarehouseTransferProductDTO>();
//get item from
List <WarehouseTransferMng_WarehouseTransferProduct_View> transferItem = context.WarehouseTransferMng_WarehouseTransferProduct_View.Where(o => o.WarehouseTransferID == id).ToList();
DTO.WarehouseTransferProductDTO dtoTransferItem;
foreach (var item in transferItem)
{
dtoTransferItem = new DTO.WarehouseTransferProductDTO();
dtoTransferItem.WarehouseTransferProductID = item.WarehouseTransferProductID;
dtoTransferItem.ProductionItemID = item.ProductionItemID;
dtoTransferItem.Quantity = item.Quantity;
dtoTransferItem.QNTBarCode = item.QNTBarCode;
dtoTransferItem.ProductionItemUD = item.ProductionItemUD;
dtoTransferItem.ProductionItemNM = item.ProductionItemNM;
dtoTransferItem.ProductionItemTypeNM = item.ProductionItemTypeNM;
editFormData.Data.WarehouseTransferProductDTOs.Add(dtoTransferItem);
}
}
else
{
editFormData.Data = new DTO.WarehouseTransferDTO();
editFormData.Data.WarehouseTransferProductDTOs = new List <DTO.WarehouseTransferProductDTO>();
editFormData.Data.WarehouseTransferDetails = new List <DTO.WarehouseTransferDetailDTO>();
editFormData.Data.ReceiptDate = DateTime.Now.ToString("dd/MM/yyyy");
}
}
//get support list
Module.Support.DAL.DataFactory support_factory = new Support.DAL.DataFactory();
editFormData.FactoryWarehouses = support_factory.GetFactoryWarehouse(companyID);
return(editFormData);
}
catch (Exception ex)
{
Exception iEx = Library.Helper.GetInnerException(ex);
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = iEx.Message;
return(editFormData);
}
}
public DTO.InitForm GetInit(int userID, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification();
notification.Type = Library.DTO.NotificationType.Success;
DTO.InitForm data = new DTO.InitForm();
Support.DAL.DataFactory supportFactory = new Support.DAL.DataFactory();
Framework.DAL.DataFactory frameworkFactory = new Framework.DAL.DataFactory();
int?companyID = frameworkFactory.GetCompanyID(userID);
data.SupportWorkCenter = supportFactory.GetWorkCenter();
data.SupportProductionTeam = supportFactory.GetProductionTeam(companyID);
data.SupportFactoryWarehouse = supportFactory.GetFactoryWarehouse(companyID);
return(data);
}
