public dynamic Create(Pharamacy p) { if (ModelState.IsValid) { MyProjectDBEntities db = new MyProjectDBEntities(); var userid = User.Identity.GetUserId(); var member = db.Members.FirstOrDefault(x => x.UserId == userid); Pharamacy pharamacy = new Pharamacy(); pharamacy.IsDeleted = false; pharamacy.PharmacyAddress = p.PharmacyAddress; pharamacy.PharmacyName = p.PharmacyName; pharamacy.PharmacyPhone = p.PharmacyPhone; if (member != null) { pharamacy.PharmacyOwnerId = member.ID; } db.Pharamacies.Add(pharamacy); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(p)); }
public ActionResult SaveComplaint(ComplainMember c) { MyProjectDBEntities db = new MyProjectDBEntities(); ComplainMember complainMember = new ComplainMember(); Complaint complaint = new Complaint(); Member member = new Member(); Gender gender = new Gender(); gender.GenderName = c.Gender.GenderName; member.FullName = c.Member.FullName; member.Age = c.Member.Age; complaint.AvialableRespondNotes = c.Complaint.AvialableRespondNotes; complaint.IsDeleted = false; complaint.ComplainDate = c.Complaint.ComplainDate; complaint.ComplaintDescription = c.Complaint.ComplaintDescription; if (Session["ComplaintFile"] != null) { List <string> ComplaintFiles = (List <string>)Session["ComplaintFile"]; complaint.ComplaintFilePath = ComplaintFiles[0]; Session.Remove("ComplaintFile"); } if (ModelState.IsValid) { //db.Entry(member).State = EntityState.Added; //db.Entry(gender).State = EntityState.Added; //db.Entry(complaint).State = EntityState.Added; db.Members.Add(member); db.Complaints.Add(complaint); db.Genders.Add(gender); db.SaveChanges(); return(RedirectToAction("Index")); } //if there error will view the ViewScreen Fulled with the corrupted object distributed throw the inputs return(View("AskDoctorData", c)); }
public void Dispose(bool disposing) { if (disposing) { if (context != null) { context.Dispose(); context = null; } } }
public dynamic Index() { MyProjectDBEntities db = new MyProjectDBEntities(); var tmp = db.Medicines.Where(x => x.IsDeleted == false).Select(x => new { x.ID, MedicineName = x.MedicineName == null ?"":x.MedicineName, MedicineDescription = x.MedicineDescription == null ?"":x.MedicineDescription, eday = x.ExpireDate == null ?0:x.ExpireDate.Value.Day, emonth = x.ExpireDate == null ?0:x.ExpireDate.Value.Month, eyear = x.ExpireDate == null ?0:x.ExpireDate.Value.Year, }).ToList(); return(Json(tmp, JsonRequestBehavior.AllowGet)); }
public dynamic GetMyPharmacies() { MyProjectDBEntities db = new MyProjectDBEntities(); var userid = User.Identity.GetUserId(); var member = db.Members.FirstOrDefault(x => x.UserId == userid && x.IsDeleted == false); var tmp = db.Pharamacies.Where(x => x.IsDeleted == false && x.PharmacyOwnerId == member.ID).Select(x => new{ PharmacyAddress = x.PharmacyAddress == null ?"":x.PharmacyAddress, PharmacyName = x.PharmacyName == null ?"":x.PharmacyName, PharmacyPhone = x.PharmacyPhone == null ?"":x.PharmacyPhone, FullName = x.PharmacyOwnerId == null ?"":x.Member.FullName, x.ID }).ToList(); return(Json(tmp, JsonRequestBehavior.AllowGet)); }
public ActionResult Create(Medicine m) { if (ModelState.IsValid) { MyProjectDBEntities db = new MyProjectDBEntities(); Medicine medicine = new Medicine(); medicine.MedicineName = m.MedicineName; medicine.IsDeleted = false; medicine.ExpireDate = m.ExpireDate; medicine.MedicineDescription = m.MedicineDescription; db.Medicines.Add(medicine); db.SaveChanges(); return(RedirectToAction("RequestMedicine", "Pharmacy")); } return(View(m)); }
public async Task <ActionResult> Register(RegisterViewModel model) { MyProjectDBEntities db = new MyProjectDBEntities(); if (ModelState.IsValid) { var user = new ApplicationUser() { UserName = model.Email, Email = model.Email, PhoneNumber = model.Password }; var result = await UserManager.CreateAsync(user, model.Password); if (result.Succeeded) { if (Session["RoleName"] != null) { string RoleName = Session["RoleName"].ToString(); await UserManager.AddToRoleAsync(user.Id, RoleName); Session.Remove("RoleName"); } await SignInManager.SignInAsync(user, false, false); if (Session["Mid"] != null) { int id = Convert.ToInt32(Session["Mid"].ToString()); Session.Remove("Mid"); var member = db.Members.Find(id); member.UserId = user.Id; db.Entry(member).State = EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("index", "Home")); } foreach (var error in result.Errors) { ModelState.AddModelError("", error); } } return(View(model)); }
public dynamic RequestMedicine(PharmacyMedicineRequest pmr) { if (ModelState.IsValid) { MyProjectDBEntities db = new MyProjectDBEntities(); PharmacyMedicineRequest pharmacyMedicineRequest = new PharmacyMedicineRequest(); pharmacyMedicineRequest.IsDeleted = false; pharmacyMedicineRequest.Amount = pmr.Amount; pharmacyMedicineRequest.MedicineId = pmr.MedicineId; pharmacyMedicineRequest.RequestPharamcyId = pmr.RequestPharamcyId; pharmacyMedicineRequest.RequestDate = DateTime.Now; pharmacyMedicineRequest.LatestRequestStatusId = 1; db.PharmacyMedicineRequests.Add(pharmacyMedicineRequest); db.SaveChanges(); PhMedicineRequestStatu requeststatus = new PhMedicineRequestStatu(); requeststatus.PhMedicineRequestId = pharmacyMedicineRequest.ID; requeststatus.StatusId = 1; requeststatus.StatusDate = DateTime.Now; db.PhMedicineRequestStatus.Add(requeststatus); db.SaveChanges(); } return(View(pmr)); }
public dynamic GetPhRequestedMedicine() { MyProjectDBEntities db = new MyProjectDBEntities(); var userid = User.Identity.GetUserId(); var member = db.Members.FirstOrDefault(x => x.UserId == userid); var tmp = db.PharmacyMedicineRequests.Where(x => x.IsDeleted == false && x.Pharamacy.PharmacyOwnerId == member.ID).Select(x => new { x.ID, RequestPharmacy = x.RequestPharamcyId == null ? "":x.Pharamacy.PharmacyName, MedicineName = x.MedicineId == null ?"":x.Medicine.MedicineName, Amount = x.Amount == null ?"":x.Amount, requestday = x.RequestDate == null ?0: x.RequestDate.Value.Day, requestmonth = x.RequestDate == null ?0:x.RequestDate.Value.Month, requestyear = x.RequestDate == null ?0:x.RequestDate.Value.Year, StatusName = x.LatestRequestStatusId == null ?"":x.Status.StatusName, RespondPharmacy = x.RespondPharamacyId == null ? "": x.Pharamacy1.PharmacyName, respondday = x.RespondDate == null ? 0:x.RespondDate.Value.Day, respondmonth = x.RespondDate == null ? 0:x.RespondDate.Value.Month, respondyear = x.RespondDate == null ? 0:x.RespondDate.Value.Year, }).ToList(); return(Json(tmp, JsonRequestBehavior.AllowGet)); }
public Repository() { context = new MyProjectDBEntities(); dbSet = context.Set <T>(); }
public UnitOfWork() { context = new MyProjectDBEntities(); }