public long SavePurchaseInformation(PurchaseReceive model, int userId) { long CurrentPurchaseID = 0; try { using (TransactionScope transaction = new TransactionScope()) { #region New_Purchase_Insert using (_context) { Prq_Purchase objPurchase = new Prq_Purchase(); //Random r = new Random(); //objPurchase.PurchaseNo = r.Next().ToString(); objPurchase.PurchaseNo = DalCommon.GetPreDefineNextCodeByUrl("Purchase/Purchase"); objPurchase.SupplierID = Convert.ToInt16(model.SupplierID); objPurchase.SupplierAddressID = Convert.ToInt16(model.SupplierAddressID); objPurchase.PurchaseCategory = model.PurchaseCategory; objPurchase.PurchaseType = model.PurchaseType; objPurchase.PurchaseYear = model.PurchaseYear; objPurchase.PurchaseDate = DalCommon.SetDate(model.PurchaseDate); objPurchase.PurchaseNote = model.PurchaseNote; objPurchase.RecordStatus = "NCF"; objPurchase.SetOn = DateTime.Now; objPurchase.SetBy = userId; _context.Prq_Purchase.Add(objPurchase); _context.SaveChanges(); CurrentPurchaseID = objPurchase.PurchaseID; if (model.ChallanList != null) { Prq_PurchaseChallan objChallan = new Prq_PurchaseChallan(); objChallan.ChallanNo = model.ChallanList.FirstOrDefault().ChallanNo; objChallan.PurchaseID = CurrentPurchaseID; objChallan.SourceID = model.ChallanList.FirstOrDefault().SourceID; objChallan.LocationID = model.ChallanList.FirstOrDefault().LocationID; objChallan.ReceiveStore = DalCommon.GetStoreCode(model.ChallanList.FirstOrDefault().ReceiveStore); objChallan.ChallanCategory = model.ChallanList.FirstOrDefault().ChallanCategory; objChallan.ChallanNote = model.ChallanList.FirstOrDefault().ChallanNote; objChallan.ChallanDate = Convert.ToDateTime(model.ChallanList.FirstOrDefault().ChallanDate); objChallan.RecordStatus = "NCF"; objChallan.SetOn = DateTime.Now; objChallan.SetBy = userId; _context.Prq_PurchaseChallan.Add(objChallan); _context.SaveChanges(); var CurrentChallanNo = objChallan.ChallanID; if (model.ChallanItemList != null) { foreach (var ChallanItem in model.ChallanItemList) { Prq_PurchaseChallanItem objPurchaseChallanItem = new Prq_PurchaseChallanItem(); objPurchaseChallanItem.ChallanID = CurrentChallanNo; objPurchaseChallanItem.ItemCategory = "Leather"; objPurchaseChallanItem.ItemTypeID = DalCommon.GetItemTypeCode(ChallanItem.ItemTypeID); objPurchaseChallanItem.ItemSizeID = DalCommon.GetSizeCode(ChallanItem.ItemSizeID); objPurchaseChallanItem.Description = ChallanItem.Description; objPurchaseChallanItem.UnitID = DalCommon.GetUnitCode(ChallanItem.UnitID); objPurchaseChallanItem.ChallanQty = ChallanItem.ChallanQty; objPurchaseChallanItem.ReceiveQty = ChallanItem.ReceiveQty; objPurchaseChallanItem.Remark = ChallanItem.Remark; objPurchaseChallanItem.RecordStatus = "NCF"; objPurchaseChallanItem.SetBy = userId; objPurchaseChallanItem.SetOn = DateTime.Now; _context.Prq_PurchaseChallanItem.Add(objPurchaseChallanItem); _context.SaveChanges(); } } } } #endregion transaction.Complete(); } return(CurrentPurchaseID); } catch (Exception e) { return(CurrentPurchaseID); } }
public long Save(PRDYearMonthCrustReqItem model, int userId) { long CurrentRequisitionItemID = 0; try { using (TransactionScope transaction = new TransactionScope()) { using (_context) { var RequisitionDateInfo = (from r in _context.PRD_YearMonthFinishReqDate.AsEnumerable() where r.RequisitionDateID == model.RequisitionDateID select r).FirstOrDefault(); RequisitionDateInfo.Remark = model.ConfirmNote; _context.SaveChanges(); #region Update_Item_Information if (model.ItemList != null) { foreach (var Item in model.ItemList) { #region New_Item_Insertion if (Item.RequisitionItemID == 0) { PRD_YearMonthFinishReqItem objItem = new PRD_YearMonthFinishReqItem(); objItem.RequisitionDateID = Item.RequisitionDateID; objItem.ScheduleItemID = Item.ScheduleItemID; objItem.ScheduleProductionNo = Item.ScheduleProductionNo; //objItem.RequisitionNo = Convert.ToInt32(model.PurchaseID); objItem.BuyerID = Item.BuyerID; objItem.BuyerOrderID = Item.BuyerOrderID; objItem.ArticleID = Item.ArticleID; objItem.ArticleNo = Item.ArticleNo; if (Item.ArticleChallanID != 0) { objItem.ArticleChallanID = Item.ArticleChallanID; objItem.ArticleChallanNo = Item.ArticleChallanNo; } objItem.AvgSize = Item.AvgSize; objItem.AvgSizeUnit = DalCommon.GetUnitCode(Item.AvgSizeUnitName); objItem.SelectionRange = Item.SelectionRange; objItem.SideDescription = Item.SideDescription; objItem.Thickness = Item.Thickness; objItem.ThicknessUnit = DalCommon.GetUnitCode(Item.ThicknessUnitName); objItem.ThicknessAt = (Item.ThicknessAt == "After Shaving" ? "AFSV" : "AFFN"); objItem.ItemTypeID = DalCommon.GetItemTypeCode(Item.ItemTypeName); objItem.LeatherStatusID = DalCommon.GetLeatherStatusCode(Item.LeatherStatusName); objItem.LeatherTypeID = DalCommon.GetLeatherTypeCode("Crust"); objItem.Remark = Item.Remarks; objItem.SetOn = DateTime.Now; objItem.SetBy = 1;; _context.PRD_YearMonthFinishReqItem.Add(objItem); _context.SaveChanges(); CurrentRequisitionItemID = objItem.RequisitionItemID; } #endregion #region Existing_Challan_Update else if (Item.RequisitionItemID != 0) { var CurrentItem = (from c in _context.PRD_YearMonthFinishReqItem.AsEnumerable() where c.RequisitionItemID == Item.RequisitionItemID select c).FirstOrDefault(); CurrentItem.RequisitionDateID = Item.RequisitionDateID; CurrentItem.ScheduleProductionNo = Item.ScheduleProductionNo; //CurrentItem.RequisitionNo = Convert.ToInt32(model.PurchaseID); CurrentItem.BuyerID = Item.BuyerID; CurrentItem.BuyerOrderID = Item.BuyerOrderID; CurrentItem.ArticleID = Item.ArticleID; CurrentItem.ArticleNo = Item.ArticleNo; if (Item.ArticleChallanID != 0) { CurrentItem.ArticleChallanID = Item.ArticleChallanID; CurrentItem.ArticleChallanNo = Item.ArticleChallanNo; } CurrentItem.AvgSize = Item.AvgSize; CurrentItem.AvgSizeUnit = DalCommon.GetUnitCode(Item.AvgSizeUnitName); CurrentItem.SelectionRange = Item.SelectionRange; CurrentItem.SideDescription = Item.SideDescription; CurrentItem.Thickness = Item.Thickness.ToString(); CurrentItem.ThicknessUnit = DalCommon.GetUnitCode(Item.ThicknessUnitName); CurrentItem.ThicknessAt = Item.ThicknessAt; CurrentItem.ItemTypeID = DalCommon.GetItemTypeCode(Item.ItemTypeName); CurrentItem.LeatherStatusID = DalCommon.GetLeatherStatusCode(Item.LeatherStatusName); CurrentItem.LeatherTypeID = DalCommon.GetLeatherTypeCode("Crust"); CurrentItem.Remark = Item.Remarks; _context.SaveChanges(); } #endregion } } #endregion #region To_Find_ColorItemID_For_Items_If_Any if (model.ColorList != null) { foreach (var Color in model.ColorList) { if (Color.RequisitionItemID != null && Color.RequisitionItemID != 0) { CurrentRequisitionItemID = Convert.ToInt64(Color.RequisitionItemID); break; } else { if (model.SelectedRequisitionItemID != 0) { CurrentRequisitionItemID = model.SelectedRequisitionItemID; } break; } } } #endregion #region Update_Color_Item_Information if (model.ColorList != null) { foreach (var Color in model.ColorList) { #region New_Color_Item_Insertion if (Color.ReqItemColorID == 0) { PRD_YearMonthFinishReqItemColor objColor = new PRD_YearMonthFinishReqItemColor(); objColor.RequisitionItemID = CurrentRequisitionItemID; objColor.ColorID = Color.ColorID; objColor.ArticleColorNo = Color.ArticleColorNo; objColor.ColorPcs = (Color.ColorPCS); objColor.ColorSide = (Color.ColorSide); objColor.ColorArea = Color.ColorArea; objColor.AreaUnit = DalCommon.GetUnitCode(Color.AreaUnitName); objColor.Remarks = Color.Remarks; objColor.SetBy = 1;; objColor.SetOn = DateTime.Now; _context.PRD_YearMonthFinishReqItemColor.Add(objColor); _context.SaveChanges(); } #endregion #region Update_Existing_Color_Item else if (Color.ReqItemColorID != 0) { var currentColorItem = (from c in _context.PRD_YearMonthFinishReqItemColor.AsEnumerable() where c.ReqItemColorID == Color.ReqItemColorID select c).FirstOrDefault(); currentColorItem.RequisitionItemID = CurrentRequisitionItemID; currentColorItem.ColorID = Color.ColorID; currentColorItem.ArticleColorNo = Color.ArticleColorNo; currentColorItem.ColorPcs = (Color.ColorPCS); currentColorItem.ColorSide = (Color.ColorSide); currentColorItem.ColorArea = Color.ColorArea; currentColorItem.AreaUnit = DalCommon.GetUnitCode(Color.AreaUnitName); currentColorItem.Remarks = Color.Remarks; currentColorItem.SetBy = 1;; currentColorItem.SetOn = DateTime.Now; _context.SaveChanges(); } #endregion } } #endregion } transaction.Complete(); } return(CurrentRequisitionItemID); } catch (Exception e) { return(0); } }
public int UpdatePurchaseInformation(PurchaseReceive model, int userId) { long CurrentChallanNo = 0; try { using (TransactionScope transaction = new TransactionScope()) { using (_context) { #region Purchase_Informaiton_Update var currentPurchase = (from p in _context.Prq_Purchase.AsEnumerable() where p.PurchaseID == Convert.ToInt64(model.PurchaseID) select p).FirstOrDefault(); if (currentPurchase.RecordStatus != "CNF") { currentPurchase.SupplierID = Convert.ToInt32(model.SupplierID); currentPurchase.SupplierAddressID = Convert.ToInt32(model.SupplierAddressID); currentPurchase.PurchaseCategory = model.PurchaseCategory; currentPurchase.PurchaseType = model.PurchaseType; currentPurchase.PurchaseYear = model.PurchaseYear; currentPurchase.PurchaseNote = model.PurchaseNote; currentPurchase.RecordStatus = "NCF"; currentPurchase.PurchaseDate = DalCommon.SetDate(model.PurchaseDate); currentPurchase.SetBy = userId; currentPurchase.SetOn = DateTime.Now; _context.SaveChanges(); } #endregion #region Update_Challan_Information if (model.ChallanList != null) { foreach (var challan in model.ChallanList) { #region New_Challan_Insertion if (challan.ChallanID == 0) { Prq_PurchaseChallan objChallan = new Prq_PurchaseChallan(); objChallan.ChallanNo = challan.ChallanNo; objChallan.PurchaseID = Convert.ToInt32(model.PurchaseID); objChallan.SourceID = challan.SourceID; objChallan.LocationID = challan.LocationID; objChallan.ReceiveStore = DalCommon.GetStoreCode(challan.ReceiveStore); objChallan.ChallanCategory = challan.ChallanCategory; objChallan.ChallanNote = challan.ChallanNote; objChallan.ChallanDate = Convert.ToDateTime(challan.ChallanDate); objChallan.RecordStatus = "NCF"; objChallan.SetOn = DateTime.Now; objChallan.SetBy = userId;; _context.Prq_PurchaseChallan.Add(objChallan); _context.SaveChanges(); CurrentChallanNo = objChallan.ChallanID; } #endregion #region Existing_Challan_Update else if (challan.ChallanID != 0 && challan.RecordStatus != "CNF" && challan.RecordStatus != "Confirmed") { var currentChallan = (from c in _context.Prq_PurchaseChallan.AsEnumerable() where c.ChallanID == challan.ChallanID select c).FirstOrDefault(); currentChallan.ChallanNo = challan.ChallanNo; //currentChallan.PurchaseID = Convert.ToInt32(model.PurchaseID); currentChallan.SourceID = challan.SourceID; currentChallan.LocationID = challan.LocationID; currentChallan.ReceiveStore = DalCommon.GetStoreCode(challan.ReceiveStore); currentChallan.ChallanCategory = challan.ChallanCategory; currentChallan.ChallanNote = challan.ChallanNote; try { //var GridChallanDate = Convert.ToDateTime(challan.ChallanDate).Date.ToString("dd/MM/yyyy"); //currentChallan.ChallanDate = DalCommon.SetDate(GridChallanDate); var GridChallanDate = challan.ChallanDate.Contains("/") ? challan.ChallanDate : Convert.ToDateTime(challan.ChallanDate).ToString("dd/MM/yyyy"); //var GridChallanDate = Convert.ToDateTime(challan.ChallanDate).ToString().Contains("/") ? challan.ChallanDate : Convert.ToDateTime(challan.ChallanDate).ToString("dd/MM/yyyy"); currentChallan.ChallanDate = DalCommon.SetDate(GridChallanDate); } catch { var GridChallanDate = Convert.ToDateTime(challan.ChallanDate).Date.ToString("dd/MM/yyyy"); currentChallan.ChallanDate = DalCommon.SetDate(GridChallanDate); //currentChallan.ChallanDate = DalCommon.SetDate(challan.ChallanDate); } currentChallan.RecordStatus = "NCF"; currentChallan.SetOn = DateTime.Now; currentChallan.SetBy = userId; _context.SaveChanges(); } #endregion } } #endregion #region To_Find_ChallanID_For_Items_If_Any if (model.ChallanItemList != null) { foreach (var challanItem in model.ChallanItemList) { if (challanItem.ChallanID != 0) { CurrentChallanNo = challanItem.ChallanID; break; } } } #endregion #region Update_Challan_Item_Information if (model.ChallanItemList != null) { foreach (var challanItem in model.ChallanItemList) { #region New_Challan_Item_Insertion if (challanItem.ChallanItemID == 0) { Prq_PurchaseChallanItem objPurchaseChallanItem = new Prq_PurchaseChallanItem(); objPurchaseChallanItem.ChallanID = CurrentChallanNo; objPurchaseChallanItem.ItemCategory = "Leather"; objPurchaseChallanItem.ItemTypeID = DalCommon.GetItemTypeCode(challanItem.ItemTypeID); objPurchaseChallanItem.ItemSizeID = DalCommon.GetSizeCode(challanItem.ItemSizeID); objPurchaseChallanItem.Description = challanItem.Description; objPurchaseChallanItem.UnitID = DalCommon.GetUnitCode(challanItem.UnitID); objPurchaseChallanItem.ChallanQty = challanItem.ChallanQty; objPurchaseChallanItem.ReceiveQty = challanItem.ReceiveQty; objPurchaseChallanItem.Remark = challanItem.Remark; objPurchaseChallanItem.RecordStatus = "NCF"; objPurchaseChallanItem.SetBy = userId;; objPurchaseChallanItem.SetOn = DateTime.Now; _context.Prq_PurchaseChallanItem.Add(objPurchaseChallanItem); _context.SaveChanges(); } #endregion #region Update_Existing_Challan_Item else if (challanItem.ChallanItemID != 0 && challanItem.RecordStatus != "CNF" && challanItem.RecordStatus != "Confirmed") { var currentChallanItem = (from c in _context.Prq_PurchaseChallanItem.AsEnumerable() where c.ChallanItemID == challanItem.ChallanItemID select c).FirstOrDefault(); currentChallanItem.ItemSizeID = DalCommon.GetSizeCode(challanItem.ItemSizeID); currentChallanItem.ItemTypeID = DalCommon.GetItemTypeCode(challanItem.ItemTypeID); currentChallanItem.UnitID = DalCommon.GetUnitCode(challanItem.UnitID); currentChallanItem.Description = challanItem.Description; currentChallanItem.ChallanQty = challanItem.ChallanQty; currentChallanItem.ReceiveQty = challanItem.ReceiveQty; currentChallanItem.Remark = challanItem.Remark; _context.SaveChanges(); } #endregion } } #endregion } transaction.Complete(); } return(1); } catch (Exception e) { return(0); } }