public static void AddNewSkladStorage(string NameFaction) { const int Pistols = 1000; const int Rifle = 1000; const int SMG = 1500; const int Shotgun = 2500; const int Melee = 2500; const int Armor = 2500; const int Medicals = 2500; switch (NameFaction) { case "Start": Dictionary <string, string> parametersStatr = new Dictionary <string, string> { { "@NameFaction", NameFaction }, { "@Pistols", Pistols.ToString() }, { "@Rifle", Rifle.ToString() }, { "@SMG", SMG.ToString() }, { "@Shotgun", Shotgun.ToString() }, { "@Melee", Melee.ToString() }, { "@Armor", Armor.ToString() }, { "@Medicals", Medicals.ToString() } }; DataTable resultStatr = Database.ExecutePreparedStatement("INSERT INTO sklad_faction_storages (NameFaction, Pistols, Rifle, SMG, Shotgun, Melee, Armor, Medicals) " + DatabaseValues, parametersStatr); break; } }
public async Task <ActionResult> DeleteConfirmed(int id) { Medicals medicals = await db.Medicals.FindAsync(id); db.Medicals.Remove(medicals); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task <ActionResult> Create([Bind(Include = "Mid,ApplicationNo,Date,HospitalName,BookedBy,Note")] Medicals medicals) { if (ModelState.IsValid) { db.Medicals.Add(medicals); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(medicals)); }
public async Task <IActionResult> Edit(Medicals medical) { var oldMedical = await imedicalsResponsitory.GetById(medical.Id); if (ModelState.IsValid) { await imedicalsResponsitory.Update(medical.Id, medical); return(RedirectToAction("index", "medicals")); } ViewBag.hospitals = ihospitalsResponsitory.GetAll().OrderBy(p => p.HospitalName).ToList(); ViewBag.companies = icompanyDetailsResponsitory.GetAll().OrderBy(p => p.CompanyName).ToList(); return(View("detail", medical)); }
public async Task <ActionResult> Edit([Bind(Include = "Mid,ApplicationNo,Date,HospitalName,BookedBy,Note,Files")] Medicals medicals, HttpPostedFileBase file, Helper help) { if (ModelState.IsValid) { medicals.Files = file != null?help.uploadfile(file) : img; db.Entry(medicals).State = EntityState.Modified; await db.SaveChangesAsync(); TempData["Success"] = "Medical Updated Successfully"; return(RedirectToAction("Dashboard", "Processing", new { id = medicals.ApplicationNo })); } return(View(medicals)); }
// GET: Medicals/Details/5 public async Task <ActionResult> Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Medicals medicals = await db.Medicals.FindAsync(id); if (medicals == null) { return(HttpNotFound()); } return(View(medicals)); }
public ActionResult Medical([Bind(Include = "Date,HospitalName,BookedBy,ApplicationNo,Note,Sms,Email,Show")] Medicals Med, Helper help) { using (var transaction = db.Database.BeginTransaction()) { try { Medicals mm = db.Medicals.FirstOrDefault(x => x.ApplicationNo == Med.ApplicationNo); if (mm == null) { var inquiryid = db.Applications.FirstOrDefault(x => x.ApplicationNo == Med.ApplicationNo).InquiryId; online onlines = db.onlines.FirstOrDefault(x => x.inquiryid == inquiryid); Med.BookedBy = help.Teacher(); Med.Date = System.DateTime.Now; db.Medicals.Add(Med); db.SaveChanges(); Process pr = db.Process.FirstOrDefault(x => x.ApplicationNo == Med.ApplicationNo); if (pr.Medical == false) { var Process = db.Process.SingleOrDefault(x => x.ApplicationNo == Med.ApplicationNo); if (Process != null) { Process.Medical = true; db.SaveChanges(); } } transaction.Commit(); if (Med.Sms == true) { help.sendsms(onlines.Mobile, "Hello," + onlines.Name + " your Medical Registerd Sucessfully "); } return(Json(Med, JsonRequestBehavior.AllowGet)); } else { TempData["danger"] = "Sorry Medical Already Booked"; return(Json(Med, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { transaction.Rollback(); throw; } return(View()); } }
public async Task <IActionResult> PostCreate(Medicals medical) { if (ModelState.IsValid) { await imedicalsResponsitory.Create(medical); return(RedirectToAction("index", "medicals")); } foreach (var modelStateKey in ModelState.Keys) { var modelStateVal = ModelState[modelStateKey]; foreach (var error in modelStateVal.Errors) { var key = modelStateKey; var errorMessage = error.ErrorMessage; Debug.WriteLine(key); Debug.WriteLine(errorMessage); } } Debug.WriteLine("LOI"); ViewBag.hospitals = ihospitalsResponsitory.GetAll().OrderBy(p => p.HospitalName).ToList(); ViewBag.companies = icompanyDetailsResponsitory.GetAll().OrderBy(p => p.CompanyName).ToList(); return(View("create")); }