public ActionResult DeleteConfirmed(int id) { VictimDetails victimDetails = db.VictimDetails.Find(id); db.VictimDetails.Remove(victimDetails); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,VictimName,Age,Address,Country,Phone,Email,Gender,RegistrationDate,OthersDetails")] VictimDetails victimDetails) { if (ModelState.IsValid) { db.Entry(victimDetails).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(victimDetails)); }
public JsonResult SaveCase(CaseDetailsVM caseDetails) { List <VictimDetails> victims = new List <VictimDetails>(); var agentId = "Pranay"; foreach (var item in caseDetails.VictimsDetails) { VictimDetails victim = new VictimDetails { Name = item.Name, Age = item.Age, ChiefComplaint = item.ChiefComplaint, Gender = item.Gender, Remarks = item.Remarks, VictimId = item.VictimId }; victims.Add(victim); } CaseDetails newCaseDetails = new CaseDetails { CallId = caseDetails.CallId, CallerName = caseDetails.CallerName, CallTime = caseDetails.CallTime, CallType = caseDetails.CallType, IncidentLocation = caseDetails.IncidentLocation, CaseStartTime = caseDetails.CaseStartTime, ContactNumber = caseDetails.ContactNumber, HospitalHandOverTime = caseDetails.HospitalHandOverTime, BackToBaseTime = caseDetails.BackToBaseTime, InstituteReachTime = caseDetails.InstituteReachTime, SceneReachTime = caseDetails.SceneReachTime, SceneDepartureTime = caseDetails.SceneDepartureTime, StandardRemark = caseDetails.StandardRemark, InstituteReachOdo = caseDetails.InstituteReachOdo, BackToBaseOdo = caseDetails.BackToBaseOdo, SceneReachOdo = caseDetails.SceneReachOdo, StartOdo = caseDetails.StartOdo, VehicleDetails = new Vehicle { VehicleId = caseDetails.VehicleDetails.VehicleId, VehicleNumber = caseDetails.VehicleDetails.VehicleNumber, State = caseDetails.VehicleDetails.State }, VictimsDetails = victims }; var status = 2; var result = callIncident.SaveNewCaseDetails(newCaseDetails, agentId, status); return(Json(new { success = true })); }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } VictimDetails victimDetails = db.VictimDetails.Find(id); if (victimDetails == null) { return(HttpNotFound()); } return(View(victimDetails)); }
public CaseDetails GetCaseDetails(string callId, string agentId) { CaseDetails selectedCase = new CaseDetails(); try { MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["gvkemricon"].ConnectionString); DataSet ds = new DataSet(); DataTable dt = new DataTable(); conn.Open(); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = conn; MySqlDataAdapter ad = new MySqlDataAdapter(cmd); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetSelectedCase"; cmd.Parameters.AddWithValue("@agentid", agentId); cmd.Parameters.AddWithValue("@vcallid", callId); ad.Fill(ds); conn.Close(); List <VictimDetails> victims = new List <VictimDetails>(); Vehicle vehicleDetails = new Vehicle(); selectedCase.CallId = ds.Tables[0].Rows[0]["callid"].ToString(); selectedCase.CallTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["entry_time"]); vehicleDetails.VehicleNumber = ds.Tables[0].Rows[0]["vehicle_no"].ToString(); vehicleDetails.VehicleId = Convert.ToInt32(ds.Tables[0].Rows[0]["vehicle_id"]); selectedCase.VehicleDetails = vehicleDetails; selectedCase.CallType = Convert.ToInt32(ds.Tables[0].Rows[0]["call_type_id"]); selectedCase.ContactNumber = ds.Tables[0].Rows[0]["phone_number"].ToString(); selectedCase.CallerName = ds.Tables[0].Rows[0]["caller_name"].ToString(); selectedCase.IncidentLocation = ds.Tables[0].Rows[0]["locality"].ToString(); selectedCase.StandardRemark = Convert.ToInt32(ds.Tables[0].Rows[0]["standard_remarks_id"]); selectedCase.CaseStartTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["start_time"]); selectedCase.SceneReachTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["scene_arrival_time"]); selectedCase.SceneDepartureTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["scene_depature_time"]); selectedCase.InstituteReachTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["institute_reach_time"]); selectedCase.HospitalHandOverTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["HandoverTime"]); selectedCase.BackToBaseTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["BacktoBaseTime"]); selectedCase.StartOdo = ds.Tables[0].Rows[0]["odo_base_start"].ToString(); selectedCase.SceneReachOdo = ds.Tables[0].Rows[0]["odo_scene"].ToString(); selectedCase.InstituteReachOdo = ds.Tables[0].Rows[0]["odo_hospital"].ToString(); selectedCase.BackToBaseOdo = ds.Tables[0].Rows[0]["odo_base_reach"].ToString(); if (ds.Tables[0].Rows.Count > 0) { for (var i = 0; i < ds.Tables[0].Rows.Count; i++) { VictimDetails victim = new VictimDetails(); victim.Name = ds.Tables[0].Rows[i]["victim_name"].ToString(); victim.Age = Convert.ToInt32(ds.Tables[0].Rows[i]["age"]); victim.Gender = ds.Tables[0].Rows[i]["gender"].ToString(); victim.Remarks = ds.Tables[0].Rows[i]["remarks"].ToString(); victim.ChiefComplaint = Convert.ToInt32(ds.Tables[0].Rows[i]["chief_complaint_id"]); victim.VictimId = Convert.ToInt32(ds.Tables[0].Rows[i]["victim_id"]); victims.Add(victim); } } selectedCase.VictimsDetails = victims; } catch (Exception e) { } return(selectedCase); }