public ActionResult CreatePractice(vwPractice objprac)
{
Practice pra = new Practice();
pra.PracticeID = objprac.PracticeID;
pra.PracticeName = objprac.PracticeName;
pra.NPI = objprac.NPI;
pra.PhoneNumber = objprac.PhoneNumber;
pra.State = objprac.State;
pra.TAXID = objprac.TAXID;
pra.ZipeCode = objprac.ZipeCode;
pra.Address1 = objprac.Address1;
pra.Address2 = objprac.Address2;
pra.City = objprac.City;
pra.Description = objprac.Description;
pra.StatusID = objprac.StatusID;
pra.Email = objprac.Email;
pra.StatusID = 1;
objDbContext.Practices.Add(pra);
objDbContext.SaveChanges();
int lastPracticeId = objDbContext.Practices.Max(item => item.PracticeID);
PracticeUser temp = new PracticeUser();
//temp = objDbContext.PracticeUsers.Find(objprac.UserID);
temp.UserName = objprac.UserName;
temp.Password = objprac.Password;
temp.PracticeUserType = "Admin";
temp.Email = objprac.Email;
temp.PhoneNumber = objprac.PhoneNumber;
temp.PracticeID = lastPracticeId;
temp.StatusID = 1;
objDbContext.PracticeUsers.Add(temp);
objDbContext.SaveChanges();
return Json(new { data = "Success" });
}
public ActionResult DeletePractice(vwPractice objprac)
{
var practiceUsers = (from p in objDbContext.PracticeUsers
where p.PracticeID == objprac.PracticeID
select p).ToList();
foreach (var n in practiceUsers)
{
n.StatusID = 2;
}
Practice pra = (from p in objDbContext.Practices
where p.PracticeID == objprac.PracticeID
select p).FirstOrDefault();
pra.StatusID = 2;
objDbContext.SaveChanges();
return Json(new { data = "Success" });
}
public ActionResult GetPracticesData(vwPractice objpractice)
{
var practiceslist = (from p in objDbContext.vwPractices
where p.PracticeID == objpractice.PracticeID
select p).ToList();
return Json(practiceslist);
}
public ActionResult EditPractice(vwPractice objprac)
{
Practice pra = (from p in objDbContext.Practices
where p.PracticeID == objprac.PracticeID
select p).FirstOrDefault();
pra.PracticeID = objprac.PracticeID;
pra.PracticeName = objprac.PracticeName;
pra.NPI = objprac.NPI;
pra.PhoneNumber = objprac.PhoneNumber;
pra.State = objprac.State;
pra.TAXID = objprac.TAXID;
pra.ZipeCode = objprac.ZipeCode;
pra.Address1 = objprac.Address1;
pra.Address2 = objprac.Address2;
pra.City = objprac.City;
pra.Description = objprac.Description;
pra.StatusID = 1;
pra.Email = objprac.Email;
PracticeUser temp = new PracticeUser();
temp = objDbContext.PracticeUsers.Find(objprac.UserID);
temp.UserName = objprac.UserName;
temp.Password = objprac.Password;
temp.PracticeUserType = "Admin";
//if (ModelState.IsValid)
//{
// objDbContext.Entry(pra).State = EntityState.Modified;
// objDbContext.Entry(temp).State = EntityState.Modified;
// objDbContext.SaveChanges();
// return RedirectToAction("Superadminsection");
//}
objDbContext.SaveChanges();
return Json(new { data = "Success" });
}