public ActionResult PatientImageManager(PatientImageManager obj) { BL_PatientImageManager BL_obj = new BL_PatientImageManager(); HospitalLocationID(); obj.PatientName = Request.Form["PatientName"]; obj.Gender = Request.Form["Gender"]; obj.PatientRegNo = Convert.ToInt32(Request.Form["PatientRegNo"]); obj.OPDIPDID = Convert.ToInt32(Request.Form["OPDIPDID"]); obj.PatientType = Request.Form["PatientType"]; obj.PaperName = Request.Form["file"]; obj.PatientName = Request.Form["PatientName"]; obj.Gender = Request.Form["Gender"]; obj.ConsultantDr = Request.Form["DoctorName"]; obj.ReferredByDoctor = Request.Form["DoctorName"]; obj.CasePaperID = Request.Form["CasePaperID"].ToString(); //obj.PaperPath = Request.Form["Paper"].ToString(); obj.Paper = Request.Form["path"].ToString(); if (Request.Form["PaperPath"] != null && Request.Form["PaperPath"].ToString() != "") { obj.PaperPath = Request.Form["PaperPath"].ToString(); } if (BL_obj.Save(obj)) { return(RedirectToAction("PatientImageManager", "PatientImageManager")); } return(View()); }
public FileResult DownLoadFile(int CasePaperID) { byte[] bytes; string fileName, contentType, PaperPath; List <string[]> lists = new List <string[]>(); PatientImageManager PMRDModel = new PatientImageManager(); string Constring = ConfigurationManager.ConnectionStrings["Mycon"].ToString(); SqlConnection con = new SqlConnection(Constring); HospitalLocationID(); SqlCommand cmd = new SqlCommand("GetPatientImageManagerParticular", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); cmd.Parameters.AddWithValue("@CasePaperID", CasePaperID); con.Open(); using (SqlDataReader sdr = cmd.ExecuteReader()) { sdr.Read(); // bytes = (byte[])sdr["PaperName"]; PaperPath = sdr["PaperPath"].ToString(); fileName = sdr["PaperName"].ToString(); contentType = MimeMapping.GetMimeMapping(PaperPath); } con.Close(); return(File(PaperPath, contentType, fileName)); }
public JsonResult imageuplod(PatientImageManager model) { string path = ""; //PatientMRD_Model Model // PatientMRD_Model obj = new PatientMRD_Model(); var file = model.ImageFile; if (file != null) { //var path = ""; var filename = Path.GetFileName(file.FileName); var extention = Path.GetExtension(file.FileName); var filenamethoutextenction = Path.GetFileNameWithoutExtension(file.FileName); // file.SaveAs(Server.MapPath("~/MRDFiles/" + file.FileName)); // Session["Paper"] = "/MRDFiles/" + file.FileName; path = Server.MapPath("~/") + "MRDFiles/" + file.FileName; file.SaveAs(path); // Session["Paper"] = path; path = "/MRDFiles/" + file.FileName; //ViewData["ImagePath"] = "/MRDFiles/" + file1.FileName; Session["Paper"] = "/MRDFiles/" + file.FileName; } return(new JsonResult { Data = path, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public ActionResult GetFile(int PatientRegNo) { SqlDataReader rdr; byte[] Paper = null; string PaperName = ""; string PaperPath = ""; HospitalLocationID(); DataSet ds = BL_obj.GetPatientImageManager(HospitalID, LocationID, Convert.ToInt32(PatientRegNo)); List <string[]> search = new List <string[]>(); PatientImageManager PMRDModel = new PatientImageManager(); List <PatientImageManager> lists = new List <PatientImageManager>(); if (ds.Tables[1].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[1].Rows) { lists.Add(new Models.Patient.PatientImageManager { CasePaperID = dr["CasePaperID"].ToString(), PatientRegNo = Convert.ToInt32(dr["PatientRegNO"]), OPDIPDID = Convert.ToInt32(dr["OPDIPDID"]), PatientType = dr["PatientType"].ToString(), PaperName = dr["PaperName"].ToString(), PaperPath = dr["PaperPath"].ToString(), }); } } return(Json(lists)); }
public JsonResult BindNamebyRegNo(string PatientRegNo) { HospitalLocationID(); DataSet ds = BL_obj.GetPatientImageManager(HospitalID, LocationID, Convert.ToInt32(PatientRegNo)); List <PatientImageManager> lists = new List <PatientImageManager>(); PatientImageManager PMRDModel = new PatientImageManager(); foreach (DataRow dr in ds.Tables[0].Rows) { if (dr["AgeType"].ToString() == "Days") { string Daye = DateTime.Now.AddDays(Convert.ToInt32(dr["Age"])).ToString(); dr["Age"] = Convert.ToDateTime(Daye).Year - DateTime.Now.Year; } //PMRDModel.CasePaperID = dr["CasePaperID"].ToString(); PMRDModel.PatientName = dr["PatientName"].ToString(); PMRDModel.PatientRegNo = Convert.ToInt32(dr["PatientRegNO"].ToString()); PMRDModel.OPDIPDID = Convert.ToInt32(dr["OPDIPDID"].ToString()); PMRDModel.PatientType = dr["PatientType"].ToString(); PMRDModel.MobileNo = dr["MobileNo"].ToString(); PMRDModel.Age = Convert.ToInt32(dr["Age"].ToString()); PMRDModel.Gender = dr["Gender"].ToString(); PMRDModel.Address = dr["Address"].ToString(); PMRDModel.GuardianName = dr["GuardianName"].ToString(); } if (ds.Tables[1].Rows.Count > 0) { foreach (DataRow rows in ds.Tables[1].Rows) { PMRDModel.PaperPath = rows["PaperPath"].ToString(); } } lists.Add(PMRDModel); return(new JsonResult { Data = lists, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public bool Save(PatientImageManager obj) { // string id = obj.PatientRegNO.ToString(); try { Connect(); #region IUPatientImageManager //string[] Paper = obj.Paper.Split(','); string[] Papername = obj.PaperPath.Split(','); string[] CasepapID = obj.CasePaperID.Split(','); for (int i = 0; i < Papername.Length; i++) { SqlCommand cmPatientMRD = new SqlCommand("IUPatientImageManager", con); cmPatientMRD.CommandType = CommandType.StoredProcedure; cmPatientMRD.Parameters.AddWithValue("@HospitalID", HospitalID); cmPatientMRD.Parameters.AddWithValue("@LocationID", LocationID); if (CasepapID[i] == "0" || CasepapID[i] == null) { cmPatientMRD.Parameters.AddWithValue("@CasePaperID", 0); cmPatientMRD.Parameters["@CasePaperID"].Direction = ParameterDirection.Output; cmPatientMRD.Parameters.AddWithValue("@Mode", "Add"); } else { cmPatientMRD.Parameters.AddWithValue("@CasePaperID", CasepapID[i]); cmPatientMRD.Parameters.AddWithValue("@Mode", "Edit"); } cmPatientMRD.Parameters.AddWithValue("@PatientRegNO", obj.PatientRegNo); cmPatientMRD.Parameters.AddWithValue("@OPDIPDID", obj.OPDIPDID); //cmPatientMRD.Parameters.AddWithValue("@PatientIPDNO", obj.OPDIPDID); cmPatientMRD.Parameters.AddWithValue("@PatientType", obj.PatientType); cmPatientMRD.Parameters.AddWithValue("@PaperType", ""); cmPatientMRD.Parameters.AddWithValue("@Paper", ""); if (Papername[i] == null) { cmPatientMRD.Parameters.AddWithValue("@PaperPath", ""); } else { cmPatientMRD.Parameters.AddWithValue("@PaperPath", Papername[i]); } cmPatientMRD.Parameters.AddWithValue("@PaperName", Papername[i].Replace("/MRDFiles/", "")); cmPatientMRD.Parameters.AddWithValue("@ConsultantDrID", 0); cmPatientMRD.Parameters.AddWithValue("@ConsultantDrName", ""); cmPatientMRD.Parameters.AddWithValue("@ReferredDrID", 0); cmPatientMRD.Parameters.AddWithValue("@ReferredDrName", ""); if (obj.CreationID != null) { cmPatientMRD.Parameters.AddWithValue("@CreationID", UserID); } else { cmPatientMRD.Parameters.AddWithValue("@CreationID", UserID); } con.Open(); cmPatientMRD.ExecuteNonQuery(); con.Close(); int CasePaperID = Convert.ToInt32(cmPatientMRD.Parameters["@CasePaperID"].Value.ToString()); #endregion } } catch (Exception ex) { } return(true); }