/// <summary>
/// Add/Remove existing treatment mappings with service
/// </summary>
/// <param name="companyID"></param>
/// <param name="NewCreatedTreatment"></param>
public void AddRmvExstngTrtmnts(Int64 companyID, CreateEditTrtmntViewModel NewCreatedTreatment)
{
////using dapper.net
string qryInsertListIntoXrefServiceTreatment = @"insert into [dbo].[XrefServiceTreatment] ([ServiceID], [TreatmentID], [CompanyID]) values (@ServiceID, @TreatmentID, @CompanyID)";
this._con.Open();
IDbTransaction transact = this._con.BeginTransaction();
//first delete all svc-trtmnt mappings from XrefServiceTreatment table
this._con.DeleteList<XrefServiceTreatment>(" where ServiceID = " + NewCreatedTreatment.SvcID, transact);
// if treatments are checked - enter values only into XrefServiceTreatment
foreach (var item in NewCreatedTreatment.ExistingTreatments)
{
if (item.CheckedStatus)
{
//insert into XrefServiceTreatment
////insert List using dapper.net
XrefServiceTreatment newXref = new XrefServiceTreatment(NewCreatedTreatment.SvcID, item.TreatmentID, companyID);
this._con.Execute(qryInsertListIntoXrefServiceTreatment, newXref, transact);
}
}
transact.Commit();
this._con.Close();
return;
}
public ActionResult AddRmvExstngTrtmnts(CreateEditTrtmntViewModel NewCreatedTreatment)
{
var account = new AccountController();
var currentUser = account.UserManager.FindById(User.Identity.GetUserId());
//perform db operation to add Treatment
this._svcTrtmntRepository.AddRmvExstngTrtmnts(currentUser.CompanyID, NewCreatedTreatment);
return RedirectToAction("Index");
}
public ActionResult CreateTreatment2(string SvcDetails)
{
var account = new AccountController();
var currentUser = account.UserManager.FindById(User.Identity.GetUserId());
CreateEditTrtmntViewModel objNewTrtmnt = new CreateEditTrtmntViewModel();
//getting service Id and name - associated with treatment
objNewTrtmnt.SvcID = Convert.ToInt64(SvcDetails.Split(new char[] { '~' })[0]);
objNewTrtmnt.SvcName = SvcDetails.Split(new char[] { '~' })[1];
objNewTrtmnt.NewTreatment = new Treatment();
objNewTrtmnt.ExistingTreatments = (IList<BasicTreatmentViewModel>)this._svcTrtmntRepository.GetAllTreatments(currentUser.CompanyID, objNewTrtmnt.SvcID);
return PartialView("_CreateTreatment2", objNewTrtmnt);
}
/// <summary>
/// Create new treatment and add reference into XrefServiceTreatment table
/// </summary>
/// <param name="companyID"></param>
/// <param name="NewCreatedTreatment"></param>
public void CreateNewTreatment(Int64 companyID, CreateEditTrtmntViewModel NewCreatedTreatment)
{
// newTrtmntID = newly created treatment id
long newTrtmntID = this._con.Insert<long>(new Treatment
{
CompanyID = companyID,
TreatmentName = NewCreatedTreatment.NewTreatment.TreatmentName,
TreatmentDesc = NewCreatedTreatment.NewTreatment.TreatmentDesc,
TreatmentDuration = NewCreatedTreatment.NewTreatment.TreatmentDuration
});
//insert into XrefServiceTreatment table
this._con.Insert<long>(new XrefServiceTreatment
{
CompanyID = companyID,
ServiceID = NewCreatedTreatment.SvcID,
TreatmentID = newTrtmntID,
});
}
/// <summary>
/// Manage treatments
/// </summary>
/// <returns></returns>
public ActionResult ManageTrtmnt()
{
var account = new AccountController();
var currentUser = account.UserManager.FindById(User.Identity.GetUserId());
CreateEditTrtmntViewModel objNewTrtmnt = new CreateEditTrtmntViewModel();
objNewTrtmnt.ExistingTreatments = (IList<BasicTreatmentViewModel>)this._svcTrtmntRepository.GetAllTreatments(currentUser.CompanyID, -1);
return PartialView("_ManageTreatment", objNewTrtmnt);
}
