public ValidationMsg Save(PrqPurchaseYearPeriod model) { _vmMsg = new ValidationMsg(); try { #region Save Detail Records if (model.PurchaseYearPeriodItemList != null) { foreach (PrqPurchaseYearPeriodItem objPrqPurchaseYearPeriodItem in model.PurchaseYearPeriodItemList) { if (objPrqPurchaseYearPeriodItem.PeriodItemID == 0) { objPrqPurchaseYearPeriodItem.PeriodID = model.PeriodID; Prq_PurchaseYearPeriodItem tblPurchaseYearPeriodItem = SetToModelObject(objPrqPurchaseYearPeriodItem); _context.Prq_PurchaseYearPeriodItem.Add(tblPurchaseYearPeriodItem); } else { Prq_PurchaseYearPeriodItem CurrentEntity = SetToModelObject(objPrqPurchaseYearPeriodItem); var OriginalEntity = _context.Prq_PurchaseYearPeriodItem.First(m => m.PeriodItemID == objPrqPurchaseYearPeriodItem.PeriodItemID); OriginalEntity.ItemTypeID = CurrentEntity.ItemTypeID; OriginalEntity.LeatherType = CurrentEntity.LeatherType; OriginalEntity.LeatherStatus = CurrentEntity.LeatherStatus; OriginalEntity.SizeID = CurrentEntity.SizeID; OriginalEntity.TargetQuantity = CurrentEntity.TargetQuantity; OriginalEntity.UnitID = CurrentEntity.UnitID; OriginalEntity.TargetValue = CurrentEntity.TargetValue; OriginalEntity.CurrencyID = CurrentEntity.CurrencyID; } } } _context.SaveChanges(); _vmMsg.Type = Enums.MessageType.Success; _vmMsg.Msg = "Save Successfully."; #endregion } catch (Exception e) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to save."; } return(_vmMsg); }
public Prq_PurchaseYearPeriodItem SetToModelObject(PrqPurchaseYearPeriodItem model) { Prq_PurchaseYearPeriodItem Entity = new Prq_PurchaseYearPeriodItem(); Entity.PeriodItemID = model.PeriodItemID; Entity.PeriodID = model.PeriodID; Entity.ItemTypeID = _context.Sys_ItemType.Where(m => m.ItemTypeName == model.ItemTypeName).FirstOrDefault().ItemTypeID; Entity.LeatherType = 1; Entity.LeatherStatus = _context.Sys_LeatherStatus.Where(m => m.LeatherStatusName == model.LeatherStatusName).FirstOrDefault().LeatherStatusID; Entity.SizeID = _context.Sys_Size.Where(m => m.SizeName == model.SizeName).FirstOrDefault().SizeID; Entity.PeriodID = model.PeriodID; Entity.TargetQuantity = model.TargetQuantity; Entity.TargetValue = model.TargetValue; Entity.UnitID = _context.Sys_Unit.Where(m => m.UnitName == model.UnitName).FirstOrDefault().UnitID; Entity.CurrencyID = _context.Sys_Currency.Where(m => m.CurrencyName == model.CurrencyName).FirstOrDefault().CurrencyID; Entity.RecordStatus = "NCF"; Entity.SetOn = DateTime.Now; Entity.SetBy = model.SetBy; Entity.IPAddress = string.Empty; return(Entity); }
public PrqPurchaseYearPeriodItem SetToBussinessObject(Prq_PurchaseYearPeriodItem Entity) { PrqPurchaseYearPeriodItem Model = new PrqPurchaseYearPeriodItem(); Model.PeriodItemID = Entity.PeriodItemID; Model.ItemTypeID = Entity.ItemTypeID; Model.ItemTypeName = _context.Sys_ItemType.Where(m => m.ItemTypeID == Entity.ItemTypeID).FirstOrDefault().ItemTypeName; Model.LeatherType = Entity.LeatherType; //Model.LeatherTypeName = _context.Sys_LeatherType.Where(m => m.LeatherTypeID == Entity.LeatherType).FirstOrDefault().LeatherTypeName; Model.LeatherStatusID = Entity.LeatherStatus; Model.LeatherStatusName = _context.Sys_LeatherStatus.Where(m => m.LeatherStatusID == Entity.LeatherStatus).FirstOrDefault().LeatherStatusName; Model.SizeID = Entity.SizeID; Model.SizeName = _context.Sys_Size.Where(m => m.SizeID == Entity.SizeID).FirstOrDefault().SizeName; Model.TargetQuantity = Entity.TargetQuantity; Model.UnitID = Entity.UnitID; Model.UnitName = _context.Sys_Unit.Where(m => m.UnitID == Entity.UnitID).FirstOrDefault().UnitName; Model.TargetValue = Entity.TargetValue; Model.CurrencyID = Entity.CurrencyID; Model.CurrencyName = _context.Sys_Currency.Where(m => m.CurrencyID == Entity.CurrencyID).FirstOrDefault().CurrencyName; return(Model); }
public ValidationMsg Save(PrqPurchaseYearTarget model, int userid) { _vmMsg = new ValidationMsg(); try { IList <string> periodlist = new List <string>(); periodlist.Add(model.YearStartDate); foreach (var period in model.PeriodList) { periodlist.Add(period.StartDate.Contains("/") ? period.StartDate : Convert.ToDateTime(period.StartDate).ToString("dd/MM/yyyy")); periodlist.Add(period.EndDate.Contains("/") ? period.EndDate : Convert.ToDateTime(period.EndDate).ToString("dd/MM/yyyy")); } for (int i = 1; i <= periodlist.Count - 1; i++) { double day = (DalCommon.SetDate(periodlist[i]) - DalCommon.SetDate(periodlist[i - 1])).TotalDays; if (i != 1) { if (day <= 0) { error = 1; break; } } } if (error == 0) { #region Save using (var tx = new TransactionScope()) { using (_context) { var exitData = _context.Prq_PurchaseYearTarget.Where(m => m.PurchaseYear == model.PurchaseYear).ToList(); if (exitData.Count > 0) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Alreary Exit This Year."; } else { model.SetBy = userid; Prq_PurchaseYearTarget tblPurchaseYearTarget = SetToModelObject(model); _context.Prq_PurchaseYearTarget.Add(tblPurchaseYearTarget); _context.SaveChanges(); #region Save Period Records if (model.PurchaseYearPeriodList != null) { foreach (PrqPurchaseYearPeriod objPrqPurchaseYearPeriod in model.PurchaseYearPeriodList) { ////var yearStartDate = Convert.ToDateTime(objPrqPurchaseYearPeriod.StartDate).Date; ////var yearEndDate = Convert.ToDateTime(objPrqPurchaseYearPeriod.EndDate).Date; //objPrqPurchaseYearPeriod.SetBy = userid; //objPrqPurchaseYearPeriod.StartDate = // Convert.ToDateTime(objPrqPurchaseYearPeriod.StartDate) // .Date.ToString("dd/MM/yyyy"); //objPrqPurchaseYearPeriod.EndDate = // Convert.ToDateTime(objPrqPurchaseYearPeriod.EndDate) // .Date.ToString("dd/MM/yyyy"); objPrqPurchaseYearPeriod.StartDate = objPrqPurchaseYearPeriod.StartDate.Contains("/") ? objPrqPurchaseYearPeriod.StartDate : Convert.ToDateTime(objPrqPurchaseYearPeriod.StartDate).ToString("dd/MM/yyyy"); objPrqPurchaseYearPeriod.EndDate = objPrqPurchaseYearPeriod.EndDate.Contains("/") ? objPrqPurchaseYearPeriod.EndDate : Convert.ToDateTime(objPrqPurchaseYearPeriod.EndDate).ToString("dd/MM/yyyy"); objPrqPurchaseYearPeriod.YearID = tblPurchaseYearTarget.YearID; Prq_PurchaseYearPeriod tblPurchaseYearPeriod = SetToModelObject(objPrqPurchaseYearPeriod); _context.Prq_PurchaseYearPeriod.Add(tblPurchaseYearPeriod); _context.SaveChanges(); #region Save Period Item List if (model.PurchaseYearPeriodItemList != null) { foreach ( PrqPurchaseYearPeriodItem objPrqPurchaseYearPeriodItem in model.PurchaseYearPeriodItemList) { objPrqPurchaseYearPeriodItem.PeriodID = tblPurchaseYearPeriod.PeriodID; objPrqPurchaseYearPeriodItem.SetBy = userid; Prq_PurchaseYearPeriodItem tblPurchaseYearPeriodItem = SetToModelObject(objPrqPurchaseYearPeriodItem); _context.Prq_PurchaseYearPeriodItem.Add(tblPurchaseYearPeriodItem); } } #endregion } } _context.SaveChanges(); #endregion tx.Complete(); YearID = tblPurchaseYearTarget.YearID; _vmMsg.Type = Enums.MessageType.Success; _vmMsg.Msg = "Saved Successfully."; } } } #endregion } else { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Period is not Properly Define."; } } catch { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to save."; } return(_vmMsg); }
public ValidationMsg Update(PrqPurchaseYearTarget model, int userid) { _vmMsg = new ValidationMsg(); try { IList <string> periodlist = new List <string>(); periodlist.Add(model.YearStartDate); foreach (var period in model.PeriodList) { periodlist.Add(period.StartDate.Contains("/") ? period.StartDate : Convert.ToDateTime(period.StartDate).ToString("dd/MM/yyyy")); periodlist.Add(period.EndDate.Contains("/") ? period.EndDate : Convert.ToDateTime(period.EndDate).ToString("dd/MM/yyyy")); } for (int i = 1; i <= periodlist.Count - 1; i++) { double day = (DalCommon.SetDate(periodlist[i]) - DalCommon.SetDate(periodlist[i - 1])).TotalDays; if (day < 0) { error = 1; break; } } if (error == 0) { #region Update using (var tx = new TransactionScope()) { using (_context) { Prq_PurchaseYearTarget CurrentEntity = SetToModelObject(model); var OriginalEntity = _context.Prq_PurchaseYearTarget.First(m => m.YearID == model.YearID); OriginalEntity.PurchaseYear = CurrentEntity.PurchaseYear; OriginalEntity.YearStartDate = CurrentEntity.YearStartDate; OriginalEntity.YearEndDate = CurrentEntity.YearEndDate; OriginalEntity.ModifiedBy = userid; OriginalEntity.ModifiedOn = DateTime.Now; #region Save Period Records if (model.PurchaseYearPeriodList != null) { foreach (PrqPurchaseYearPeriod objPrqPurchaseYearPeriod in model.PurchaseYearPeriodList) { objPrqPurchaseYearPeriod.StartDate = objPrqPurchaseYearPeriod.StartDate.Contains("/") ? objPrqPurchaseYearPeriod.StartDate : Convert.ToDateTime(objPrqPurchaseYearPeriod.StartDate).ToString("dd/MM/yyyy"); objPrqPurchaseYearPeriod.EndDate = objPrqPurchaseYearPeriod.EndDate.Contains("/") ? objPrqPurchaseYearPeriod.EndDate : Convert.ToDateTime(objPrqPurchaseYearPeriod.EndDate).ToString("dd/MM/yyyy"); //objPrqPurchaseYearPeriod.StartDate = // Convert.ToDateTime(objPrqPurchaseYearPeriod.StartDate) // .Date.ToString("dd/MM/yyyy"); //objPrqPurchaseYearPeriod.EndDate = // Convert.ToDateTime(objPrqPurchaseYearPeriod.EndDate) // .Date.ToString("dd/MM/yyyy"); if (objPrqPurchaseYearPeriod.PeriodID == 0) { objPrqPurchaseYearPeriod.YearID = model.YearID; objPrqPurchaseYearPeriod.SetBy = userid; Prq_PurchaseYearPeriod tblPurchaseYearPeriod = SetToModelObject(objPrqPurchaseYearPeriod); _context.Prq_PurchaseYearPeriod.Add(tblPurchaseYearPeriod); PeriodID = tblPurchaseYearPeriod.PeriodID; } else { Prq_PurchaseYearPeriod CurEntity = SetToModelObject(objPrqPurchaseYearPeriod); var OrgEntity = _context.Prq_PurchaseYearPeriod.First(m => m.PeriodID == objPrqPurchaseYearPeriod.PeriodID); OrgEntity.StartDate = CurEntity.StartDate; OrgEntity.EndDate = CurEntity.EndDate; OrgEntity.ModifiedBy = userid; OrgEntity.ModifiedOn = DateTime.Now; } #region Save Period Item List if (model.PurchaseYearPeriodItemList != null) { foreach ( PrqPurchaseYearPeriodItem objPrqPurchaseYearPeriodItem in model.PurchaseYearPeriodItemList) { if (objPrqPurchaseYearPeriodItem.PeriodItemID == 0) { objPrqPurchaseYearPeriodItem.PeriodID = PeriodID; objPrqPurchaseYearPeriodItem.SetBy = userid; Prq_PurchaseYearPeriodItem tblPurchaseYearPeriodItem = SetToModelObject(objPrqPurchaseYearPeriodItem); _context.Prq_PurchaseYearPeriodItem.Add(tblPurchaseYearPeriodItem); } else { Prq_PurchaseYearPeriodItem CurrEntity = SetToModelObject(objPrqPurchaseYearPeriodItem); var OrgrEntity = _context.Prq_PurchaseYearPeriodItem.First( m => m.PeriodItemID == objPrqPurchaseYearPeriodItem.PeriodItemID); OrgrEntity.ItemTypeID = CurrEntity.ItemTypeID; OrgrEntity.LeatherType = CurrEntity.LeatherType; OrgrEntity.LeatherStatus = CurrEntity.LeatherStatus; OrgrEntity.SizeID = CurrEntity.SizeID; OrgrEntity.TargetQuantity = CurrEntity.TargetQuantity; OrgrEntity.UnitID = CurrEntity.UnitID; OrgrEntity.TargetValue = CurrEntity.TargetValue; OrgrEntity.CurrencyID = CurrEntity.CurrencyID; OrgrEntity.RecordStatus = CurrEntity.RecordStatus; } } } #endregion } } else { #region Save Period Item List if (model.PurchaseYearPeriodItemList != null) { foreach ( PrqPurchaseYearPeriodItem objPrqPurchaseYearPeriodItem in model.PurchaseYearPeriodItemList) { if (objPrqPurchaseYearPeriodItem.PeriodItemID == 0) { objPrqPurchaseYearPeriodItem.PeriodID = model.PeriodID; Prq_PurchaseYearPeriodItem tblPurchaseYearPeriodItem = SetToModelObject(objPrqPurchaseYearPeriodItem); _context.Prq_PurchaseYearPeriodItem.Add(tblPurchaseYearPeriodItem); } else { Prq_PurchaseYearPeriodItem CurrEntity = SetToModelObject(objPrqPurchaseYearPeriodItem); var OrgrEntity = _context.Prq_PurchaseYearPeriodItem.First( m => m.PeriodItemID == objPrqPurchaseYearPeriodItem.PeriodItemID); OrgrEntity.ItemTypeID = CurrEntity.ItemTypeID; OrgrEntity.LeatherType = CurrEntity.LeatherType; OrgrEntity.LeatherStatus = CurrEntity.LeatherStatus; OrgrEntity.SizeID = CurrEntity.SizeID; OrgrEntity.TargetQuantity = CurrEntity.TargetQuantity; OrgrEntity.UnitID = CurrEntity.UnitID; OrgrEntity.TargetValue = CurrEntity.TargetValue; OrgrEntity.CurrencyID = CurrEntity.CurrencyID; OrgrEntity.RecordStatus = CurrEntity.RecordStatus; } } } #endregion } _context.SaveChanges(); #endregion tx.Complete(); _vmMsg.Type = Enums.MessageType.Update; _vmMsg.Msg = "Updated Successfully."; } } #endregion } else { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Period is not Properly Define."; } } catch { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to Update."; } return(_vmMsg); }