public int UpdateMBAnalysisInContract(ContractsAndMBAnalysisType obj, int itemID, int? contractID, int? mbAnalysisTypeID, int paymentTypeID, decimal price) { if ((contractID == null) && (mbAnalysisTypeID == null)) { //ContractsAndMBAnalysisType obj = new ContractsAndMBAnalysisType(); obj = db.ContractsAndMBAnalysisTypes.Where(o => o.ContractAndMBAnalysisTypeID == itemID).SingleOrDefault(); //obj.ContractID = contractID; //obj.MBAnalysisTypeID = mbAnalysisID; obj.PaymentTypeID = paymentTypeID; obj.Price = price; obj.DateUpdate = DateTime.Now; obj.Suser = System.Web.Security.Membership.GetUser().ToString(); //db.ContractsAndMBAnalysisTypes.Attach(obj); db.ObjectStateManager.ChangeObjectState(obj, EntityState.Modified); db.SaveChanges(); } else { // ContractsAndMBAnalysisType obj = new ContractsAndMBAnalysisType(); obj = db.ContractsAndMBAnalysisTypes.Where(o => o.ContractAndMBAnalysisTypeID == itemID).SingleOrDefault(); obj.ContractID = contractID; obj.MBAnalysisTypeID = mbAnalysisTypeID; obj.PaymentTypeID = paymentTypeID; obj.Price = price; obj.DateUpdate = DateTime.Now; obj.Suser = System.Web.Security.Membership.GetUser().ToString(); //db.ContractsAndMBAnalysisTypes.Attach(obj); db.ObjectStateManager.ChangeObjectState(obj, EntityState.Modified); db.SaveChanges(); } return 0; }
public dbActionResult EditMBAnalysisInContract(ContractsAndMBAnalysisType obj) { try { obj.DateUpdate = DateTime.Now; obj.Suser = System.Web.Security.Membership.GetUser().ToString(); db.ContractsAndMBAnalysisTypes.Attach(obj); db.ObjectStateManager.ChangeObjectState(obj, EntityState.Modified); db.SaveChanges(); dbActionResult returnObj = new dbActionResult(); returnObj.intResult = obj.ContractAndMBAnalysisTypeID; returnObj.exConcur = null; returnObj.exData = null; return (returnObj); } catch (OptimisticConcurrencyException ex) { dbActionResult returnObj = new dbActionResult(); returnObj.intResult = -1; returnObj.exConcur = ex; returnObj.exData = null; return (returnObj); } catch (DataException ex) { dbActionResult returnObj = new dbActionResult(); returnObj.intResult = -2; returnObj.exConcur = null; returnObj.exData = ex; return (returnObj); } }
public int AddMBAnalysisToContract(int ContractID, int MBAnalysisID, int PaymentTypeID, decimal Price) { try { ContractsAndMBAnalysisType obj = new ContractsAndMBAnalysisType(); obj.ContractID = ContractID; obj.MBAnalysisTypeID = MBAnalysisID; obj.PaymentTypeID = PaymentTypeID; obj.Price = Price; obj.DateAdd = DateTime.Now; obj.DateUpdate = DateTime.Now; obj.Suser = System.Web.Security.Membership.GetUser().ToString(); db.ContractsAndMBAnalysisTypes.AddObject(obj); db.ObjectStateManager.ChangeObjectState(obj, EntityState.Added); db.SaveChanges(); } catch (DataException ex) { string temp = ex.Message + " Невозможно сохранить изменения. Попробуйте повторить действия. Если проблема повторится, обратитесь к системному администратору."; } //return obj.ContractAndMBAnalysisTypeID; return 0; }
/// <summary> /// Create a new ContractsAndMBAnalysisType object. /// </summary> /// <param name="contractAndMBAnalysisTypeID">Initial value of the ContractAndMBAnalysisTypeID property.</param> public static ContractsAndMBAnalysisType CreateContractsAndMBAnalysisType(global::System.Int32 contractAndMBAnalysisTypeID) { ContractsAndMBAnalysisType contractsAndMBAnalysisType = new ContractsAndMBAnalysisType(); contractsAndMBAnalysisType.ContractAndMBAnalysisTypeID = contractAndMBAnalysisTypeID; return contractsAndMBAnalysisType; }
/// <summary> /// Deprecated Method for adding a new object to the ContractsAndMBAnalysisTypes EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToContractsAndMBAnalysisTypes(ContractsAndMBAnalysisType contractsAndMBAnalysisType) { base.AddObject("ContractsAndMBAnalysisTypes", contractsAndMBAnalysisType); }
public ActionResult PartialContractMbAnalysisEdit(ContractsAndMBAnalysisType obj) { if (ModelState.IsValid) { if (obj.ContractAndMBAnalysisTypeID == -1) { db.AddMBAnalysisToContract(int.Parse(obj.ContractID.ToString()), int.Parse(obj.MBAnalysisTypeID.ToString()), int.Parse(obj.PaymentTypeID.ToString()), decimal.Parse(obj.Price.ToString())); } else { db.EditMBAnalysisInContract(obj); } ModelState.Clear(); } return RedirectToAction("EditContract", new { id = obj.ContractID, showAnalysis = 1 }); }
public ActionResult PartialContractMBAnalysisEdit(int contractMBAnalysisId = -1, int contractId = -1) { ContractsAndMBAnalysisType model = new ContractsAndMBAnalysisType(); if (contractMBAnalysisId > 0) { model = dbm.ContractsAndMBAnalysisTypes.SingleOrDefault(o => o.ContractAndMBAnalysisTypeID == contractMBAnalysisId); var itemsAnalysis = db.GetMBAnalysisTypeListActive(); List<SelectListItem> listAnalysis = new List<SelectListItem>(); foreach (var item in itemsAnalysis) { listAnalysis.Add(new SelectListItem { Text = item.DescriptionRus, Value = item.MBAnalysisTypeID.ToString() }); } var selectAnalysis = new SelectList(listAnalysis, "Value", "Text", model.MBAnalysisTypeID); var itemsPaymentType = db.GetPaymentTypeList(); List<SelectListItem> listPaymentType = new List<SelectListItem>(); foreach (var item in itemsPaymentType) { listPaymentType.Add(new SelectListItem { Text = item.Description, Value = item.PaymentTypeID.ToString() }); } var selectPaymentType = new SelectList(listPaymentType, "Value", "Text", model.PaymentTypeID ); ViewData["selectAnalysis"] = selectAnalysis; ViewData["selectPaymentType"] = selectPaymentType; ViewData["titleText"] = "Редактирование стоимости анализа"; ViewData["buttonText"] = "Сохранить"; } else { model.ContractAndMBAnalysisTypeID = -1; model.ContractID = contractId; var itemsAnalysis = db.GetMBAnalysisTypeListActive(); List<SelectListItem> listAnalysis = new List<SelectListItem>(); foreach (var item in itemsAnalysis) { listAnalysis.Add(new SelectListItem { Text = item.DescriptionRus, Value = item.MBAnalysisTypeID.ToString() }); } var selectAnalysis = new SelectList(listAnalysis, "Value", "Text"); var itemsPaymentType = db.GetPaymentTypeList(); List<SelectListItem> listPaymentType = new List<SelectListItem>(); foreach (var item in itemsPaymentType) { listPaymentType.Add(new SelectListItem { Text = item.Description, Value = item.PaymentTypeID.ToString() }); } var selectPaymentType = new SelectList(listPaymentType, "Value", "Text"); ViewData["selectAnalysis"] = selectAnalysis; ViewData["selectPaymentType"] = selectPaymentType; ViewData["titleText"] = "Добавление нового анализа в контракт"; ViewData["buttonText"] = "Добавить"; } return PartialView("PartialContractMBAnalysisEdit", model); }
public ActionResult CreateContractWithMBAnalysis(vwCreateContractWithMBAnalysis model, List<int> IDList, string[] PaymentTypeID, string[] Price) { for (int i = 0; i < IDList.Count; i++) { ContractsAndMBAnalysisType obj = new ContractsAndMBAnalysisType(); obj = db.GetContractsAndMBAnalysisType(IDList[i]); db.UpdateMBAnalysisInContract(obj, IDList[i], null, null, int.Parse(PaymentTypeID[i]), decimal.Parse(Price[i])); } return RedirectToAction("Index", new { message = "Контракт " + "'" + model.ContractItem.Description + "' с регистрационным номером " + model.ContractItem.AccountNumber + " добавлен в систему." }); }