public InvLeatherIssue SetToBussinessObject(Inv_LeatherIssue Entity) { InvLeatherIssue Model = new InvLeatherIssue(); Model.IssueID = Entity.IssueID; Model.IssueDate = Entity.IssueDate.Date.ToString("dd/MM/yyyy"); Model.IssueRef = Entity.IssueRef; Model.IssueFor = Entity.IssueFor; //switch (Entity.IssueFor) //{ // case "Leather": // Model.IssueForName = "Store Transfer"; // break; // case "Production": // Model.IssueForName = "Production"; // break; // case "Job Order": // Model.IssueForName = "Job Order"; // break; //} Model.IssueFrom = Entity.IssueFrom; Model.IssueFromName = Entity.IssueFrom == null ? "" : _context.SYS_Store.Where(m => m.StoreID == Entity.IssueFrom).FirstOrDefault().StoreName; Model.IssueTo = Entity.IssueTo; Model.IssueToName = Entity.IssueTo == null ? "" : _context.SYS_Store.Where(m => m.StoreID == Entity.IssueTo).FirstOrDefault().StoreName; Model.JobOrderNo = Entity.JobOrderNo; Model.JobOrderNo = Entity.JobOrderNo; Model.PurchaseYear = Entity.PurchaseYear; Model.RecordStatus = Entity.RecordStatus; switch (Entity.RecordStatus) { case "NCF": Model.RecordStatusName = "Not Confirmed"; break; case "CNF": Model.RecordStatusName = "Confirmed"; break; case "APV": Model.RecordStatusName = "Approved"; break; case "RCV": Model.RecordStatusName = "Received"; break; default: Model.RecordStatusName = ""; break; } return(Model); }
public ValidationMsg Save(InvLeatherIssue model, int userid) { _vmMsg = new ValidationMsg(); try { using (var tx = new TransactionScope()) { using (_context) { model.SetBy = userid; Inv_LeatherIssue tblLeatherIssue = SetToModelObject(model); _context.Inv_LeatherIssue.Add(tblLeatherIssue); _context.SaveChanges(); #region Save Detail Records if (model.LeatherIssueItemList != null) { foreach (InvLeatherIssueItem objInvLeatherIssueItem in model.LeatherIssueItemList) { objInvLeatherIssueItem.SetBy = userid; objInvLeatherIssueItem.IssueID = tblLeatherIssue.IssueID; Inv_LeatherIssueItem tblPurchaseYearPeriod = SetToModelObject(objInvLeatherIssueItem); _context.Inv_LeatherIssueItem.Add(tblPurchaseYearPeriod); } } _context.SaveChanges(); #endregion tx.Complete(); IssueID = tblLeatherIssue.IssueID; _vmMsg.Type = Enums.MessageType.Success; _vmMsg.Msg = "Saved Successfully."; } } } catch { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to save."; } return(_vmMsg); }
public Inv_LeatherIssue SetToModelObject(InvLeatherIssue model) { Inv_LeatherIssue Entity = new Inv_LeatherIssue(); Entity.IssueID = model.IssueID; Entity.IssueDate = DalCommon.SetDate(model.IssueDate);// Convert.ToDateTime(model.IssueDate).Date; Entity.IssueFor = model.IssueFor; Entity.IssueRef = model.IssueRef; Entity.IssueFrom = model.IssueFrom; Entity.IssueTo = model.IssueTo; Entity.JobOrderNo = model.JobOrderNo; Entity.PurchaseYear = model.PurchaseYear; Entity.RecordStatus = "NCF"; Entity.SetOn = DateTime.Now; Entity.SetBy = model.SetBy; Entity.IPAddress = string.Empty; return(Entity); }
public ValidationMsg Update(InvLeatherIssue model, int userid) { _vmMsg = new ValidationMsg(); try { using (var tx = new TransactionScope()) { using (_context) { Inv_LeatherIssue CurrentEntity = SetToModelObject(model); var OriginalEntity = _context.Inv_LeatherIssue.First(m => m.IssueID == model.IssueID); OriginalEntity.IssueDate = CurrentEntity.IssueDate;// Convert.ToDateTime(CurrentEntity.IssueDate).Date; OriginalEntity.IssueFor = CurrentEntity.IssueFor; OriginalEntity.IssueRef = CurrentEntity.IssueRef; OriginalEntity.IssueFrom = CurrentEntity.IssueFrom; OriginalEntity.IssueTo = CurrentEntity.IssueTo; OriginalEntity.JobOrderNo = CurrentEntity.JobOrderNo; OriginalEntity.PurchaseYear = CurrentEntity.PurchaseYear; OriginalEntity.SetBy = userid; OriginalEntity.SetOn = DateTime.Now; #region Save Detail Records if (model.LeatherIssueItemList != null) { foreach (InvLeatherIssueItem objInvLeatherIssueItem in model.LeatherIssueItemList) { if (objInvLeatherIssueItem.ItemIssueID == 0) { objInvLeatherIssueItem.IssueID = model.IssueID; Inv_LeatherIssueItem tblPurchaseYearPeriod = SetToModelObject(objInvLeatherIssueItem); _context.Inv_LeatherIssueItem.Add(tblPurchaseYearPeriod); } else { Inv_LeatherIssueItem CurEntity = SetToModelObject(objInvLeatherIssueItem); var OrgEntity = _context.Inv_LeatherIssueItem.First(m => m.ItemIssueID == objInvLeatherIssueItem.ItemIssueID); OrgEntity.SupplierID = CurEntity.SupplierID; OrgEntity.ChallanID = CurEntity.ChallanID; OrgEntity.ItemType = CurEntity.ItemType; OrgEntity.LeatherType = CurEntity.LeatherType; OrgEntity.LeatherStatus = CurEntity.LeatherStatus; OrgEntity.IssueQty = CurEntity.IssueQty; OrgEntity.UnitID = CurEntity.UnitID; OrgEntity.IssueSide = CurEntity.IssueSide; OrgEntity.Remarks = CurEntity.Remarks; OrgEntity.SetBy = userid; OrgEntity.SetOn = DateTime.Now; } } } _context.SaveChanges(); #endregion tx.Complete(); IssueID = model.IssueID; _vmMsg.Type = Enums.MessageType.Update; _vmMsg.Msg = "Updated Successfully."; } } } catch { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to Update."; } return(_vmMsg); }