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);
}
