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);
}
