public JsonResult SaveGradeSelectionData(PreGradeSelectionData model) { var confirmMessage = _dalPrqPreGradeSelection.SaveGradeSelectionData(model); return(new JsonResult { Data = confirmMessage }); }
public ValidationMsg SaveGradeSelectionData(PreGradeSelectionData model) { try { using (var tx = new TransactionScope()) { using (_context) { if (model.SelectionID == 0) { var objPreGradeSelection = new Prq_PreGradeSelection { SelectionType = "PGS", SupplierID = model.SupplierID, PurchaseID = model.PurchaseID, ItemTypeID = model.ItemTypeID, SupplierAddressID = model.SupplierAddressID, SelectionStore = model.SelectionStore, SelectionDate = Convert.ToDateTime(model.SelectionDate), SelectedBy = model.SelectedBy, SelectionComments = model.SelectionComments, ApprovedBy = model.ApprovedBy, ApproveComments = model.ApproveComments, CheckedBy = model.CheckedBy, CheckComments = model.CheckComments, RecordStatus = "NCF" }; _context.Prq_PreGradeSelection.Add(objPreGradeSelection); foreach (var gradeSelection in model.GradeSelectedList) { var objPreGradeSelectedData = new Prq_PreGradeSelectedData { SelectionID = objPreGradeSelection.SelectionID, GradeID = gradeSelection.GradeID, GradeQty = gradeSelection.GradeQty, GradeSide = gradeSelection.GradeSide, GradeArea = gradeSelection.GradeArea, UnitID = gradeSelection.UnitID, RecordStatus = "NCF", SetOn = DateTime.Now }; _context.Prq_PreGradeSelectedData.Add(objPreGradeSelectedData); } _context.SaveChanges(); } else { var query = new StringBuilder(); query.Append("Delete From Prq_PreGradeSelectedData"); query.Append(" WHERE [SelectionID] = '" + model.SelectionID + "'"); _context.Database.ExecuteSqlCommand(query.ToString()); foreach (var gradeSelection in model.GradeSelectedList) { var objPreGradeSelectedData = new Prq_PreGradeSelectedData { SelectionID = model.SelectionID, GradeID = gradeSelection.GradeID, GradeQty = gradeSelection.GradeQty, GradeArea = gradeSelection.GradeArea, UnitID = gradeSelection.UnitID, GradeSide = gradeSelection.GradeSide, RecordStatus = "NCF", SetOn = DateTime.Now }; _context.Prq_PreGradeSelectedData.Add(objPreGradeSelectedData); } _context.SaveChanges(); } tx.Complete(); _vmMsg.Type = Enums.MessageType.Success; _vmMsg.Msg = "Saved Successfully."; } } } catch (Exception) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to save."; } return(_vmMsg); }