public int AddClinic(Clinic obj) { obj.DateUpdate = DateTime.Now; obj.DateAdd = DateTime.Now; obj.Suser = System.Web.Security.Membership.GetUser().ToString(); db.Clinics.AddObject(obj); db.SaveChanges(); ClinicsAndContract objCaC = new ClinicsAndContract(); objCaC.ClinicID = obj.ClinicID; // Заменить на default objCaC.ContractID = 25; objCaC.DateUpdate = DateTime.Now; objCaC.DateAdd = DateTime.Now; objCaC.Suser = System.Web.Security.Membership.GetUser().ToString(); db.ClinicsAndContracts.AddObject(objCaC); db.SaveChanges(); ClinicsAndContract objCaC2 = new ClinicsAndContract(); objCaC2.ClinicID = obj.ClinicID; // Заменить на default objCaC2.ContractID = 26; objCaC2.DateUpdate = DateTime.Now; objCaC2.DateAdd = DateTime.Now; objCaC2.Suser = System.Web.Security.Membership.GetUser().ToString(); db.ClinicsAndContracts.AddObject(objCaC2); db.SaveChanges(); return (obj.ClinicID); }
public dbActionResult EditClinicInContract(ClinicsAndContract obj) { try { obj.DateUpdate = DateTime.Now; obj.Suser = System.Web.Security.Membership.GetUser().ToString(); db.ClinicsAndContracts.Attach(obj); db.ObjectStateManager.ChangeObjectState(obj, EntityState.Modified); db.SaveChanges(); dbActionResult returnObj = new dbActionResult(); returnObj.intResult = obj.ClinicContractID; 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 AddClinicToContract(int ContractID, int ClinicID) { var test = db.ClinicsAndContracts.SingleOrDefault(o => o.ClinicID == ClinicID && o.ContractID == ContractID); if (test == null) { ClinicsAndContract obj = new ClinicsAndContract(); obj.ContractID = ContractID; obj.ClinicID = ClinicID; obj.DateAdd = DateTime.Now; obj.DateUpdate = DateTime.Now; obj.Suser = System.Web.Security.Membership.GetUser().ToString(); db.ClinicsAndContracts.AddObject(obj); db.SaveChanges(); return obj.ClinicContractID; } else { return -1; } }
/// <summary> /// Create a new ClinicsAndContract object. /// </summary> /// <param name="clinicContractID">Initial value of the ClinicContractID property.</param> /// <param name="clinicID">Initial value of the ClinicID property.</param> /// <param name="contractID">Initial value of the ContractID property.</param> public static ClinicsAndContract CreateClinicsAndContract(global::System.Int32 clinicContractID, global::System.Int32 clinicID, global::System.Int32 contractID) { ClinicsAndContract clinicsAndContract = new ClinicsAndContract(); clinicsAndContract.ClinicContractID = clinicContractID; clinicsAndContract.ClinicID = clinicID; clinicsAndContract.ContractID = contractID; return clinicsAndContract; }
/// <summary> /// Deprecated Method for adding a new object to the ClinicsAndContracts EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToClinicsAndContracts(ClinicsAndContract clinicsAndContract) { base.AddObject("ClinicsAndContracts", clinicsAndContract); }
public ActionResult PartialContractClinicEdit(ClinicsAndContract obj ) { if (ModelState.IsValid) { if (obj.ClinicContractID == -1) { db.AddClinicToContract(obj.ContractID, obj.ClinicID); } else { db.EditClinicInContract(obj); } ModelState.Clear(); } return RedirectToAction("EditContract", new { id = obj.ContractID, showClinic = 1 }); }
public ActionResult PartialContractClinicEdit(int clinicAndContractId = -1, int contractId = -1) { ClinicsAndContract model = new ClinicsAndContract(); if (clinicAndContractId > 0) { model = dbm.ClinicsAndContracts.SingleOrDefault(o => o.ClinicContractID == clinicAndContractId); // model.ContractID = contractId; var itemsClinics = db.GetClinicList(); List<SelectListItem> listClinic = new List<SelectListItem>(); foreach (var item in itemsClinics) { listClinic.Add(new SelectListItem { Text = item.Description + " - " + item.ClinicGroup.Description, Value = item.ClinicID.ToString() }); } var selectClinic = new SelectList(listClinic, "Value", "Text", model.ClinicContractID); ViewData["selectClinic"] = selectClinic; ViewData["titleText"] = "Редактирование ЛПУ и отделения"; ViewData["buttonText"] = "Сохранить"; } else { model.ClinicContractID = -1; model.ContractID = contractId; var itemsClinics = db.GetClinicList(); List<SelectListItem> listClinic = new List<SelectListItem>(); foreach (var item in itemsClinics) { listClinic.Add(new SelectListItem { Text = item.Description + " - " + item.ClinicGroup.Description, Value = item.ClinicID.ToString() }); } var selectClinic = new SelectList(listClinic, "Value", "Text", 1); ViewData["selectClinic"] = selectClinic; ViewData["titleText"] = "Добавление нового отделения"; ViewData["buttonText"] = "Добавить"; } return PartialView("PartialContractClinicEdit", model); }