public int InsertTabandDoses(TabNameandDoses TabDoses)
{
SqlCommand cmdtab = new SqlCommand("sp_insertTabandDoses", con);
cmdtab.CommandType = CommandType.StoredProcedure;
cmdtab.Parameters.AddWithValue("@Pid", TabDoses.Pid);
cmdtab.Parameters.AddWithValue("@TABNAME", TabDoses.TabName);
cmdtab.Parameters.AddWithValue("@RpId", TabDoses.Rpid);
cmdtab.Parameters.AddWithValue("@Dosses", TabDoses.Doses1);
cmdtab.Parameters.AddWithValue("@CreatedBy", TabDoses.CreatedBy);
cmdtab.Parameters.AddWithValue("@updatedBy", TabDoses.UpdatedBy);
int i = 0;
return(i);
}
public ActionResult PatientReport(PatientReport obj, TabNameandDoses tbandDosesobj)
{
HospitalManagementEntities db = new Models.HospitalManagementEntities();
int Pid = obj.Pid <= 0 ? 0 :obj.Pid;
if (Pid != 0)
{
SqlCommand cmd = new SqlCommand("sp_insertPatientReport", con);
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Pid", Pid);
cmd.Parameters.AddWithValue("@did", 1);
cmd.Parameters.AddWithValue("@PTName", obj.PName != string.Empty?obj.PName:"");
cmd.Parameters.AddWithValue("@Gender", obj.Gender != string.Empty ? obj.PName : "");
cmd.Parameters.AddWithValue("@ReferBy", obj.Referby != string.Empty ? obj.PName : "");
cmd.Parameters.AddWithValue("@HT", obj.HT != string.Empty ? obj.PName : "");
cmd.Parameters.AddWithValue("@WT", obj.WT != string.Empty ? obj.WT : "");
cmd.Parameters.AddWithValue("@Age", obj.Age != string.Empty ? obj.Age : "");
cmd.Parameters.AddWithValue("@Emergency", obj.Emergency != string.Empty ? obj.PName : "");
cmd.Parameters.AddWithValue("@Review", obj.Reveiw != string.Empty ? obj.Reveiw : "");
cmd.Parameters.AddWithValue("@Complain", obj.Complain != string.Empty ? obj.PName : "");
cmd.Parameters.AddWithValue("@History", obj.History != string.Empty ? obj.PName : "");
cmd.Parameters.AddWithValue("@Dx", obj.Dx != string.Empty ? obj.PName : "");
cmd.Parameters.AddWithValue("@Investigation", obj.Investigation != string.Empty ? obj.PName : "");
cmd.Parameters.AddWithValue("@Advice", obj.Advice != string.Empty ? obj.PName : "");
cmd.Parameters.AddWithValue("@GC", obj.GCs != string.Empty ? obj.PName : "");
cmd.Parameters.AddWithValue("@Temp", obj.Temp != string.Empty ? obj.PName : "");
cmd.Parameters.AddWithValue("@PR", obj.PR != string.Empty ? obj.PName : "");
cmd.Parameters.AddWithValue("@LR", obj.LR != string.Empty ? obj.PName : "");
cmd.Parameters.AddWithValue("@BP", obj.BP != string.Empty ? obj.PName : "");
cmd.Parameters.AddWithValue("@SPO2", obj.SPO2 != string.Empty ? obj.PName : "");
cmd.Parameters.AddWithValue("@PA", obj.PA != string.Empty ? obj.PName : "");
cmd.Parameters.AddWithValue("@CNS", obj.CNS != string.Empty ? obj.PName : "");
cmd.Parameters.AddWithValue("@GRBS", obj.GRBS);
cmd.Parameters.AddWithValue("@HR", obj.HR != string.Empty ? obj.PName : "");
cmd.Parameters.AddWithValue("@CreatedBy", obj.CreatedBY);
cmd.Parameters.AddWithValue("@CreatedDatetime", DateTime.Now);
cmd.Parameters.AddWithValue("@UpdatedBy", obj.Updatedby);
cmd.Parameters.AddWithValue("@Updateddatetime", DateTime.Now);
Int32 i = Convert.ToInt32(cmd.ExecuteScalar());
if (i > 0)
{
TabNameandDoses tbobj = new TabNameandDoses();
StringBuilder tb = new StringBuilder();
if (tbandDosesobj.txtSearchMedicines1 != string.Empty)
{
}
tb.Append(tbandDosesobj.Doses1);
return(View(obj));
}
else
{
ViewBag.Visable = false;
ViewBag.Message = "Record Failed To Insert";
return(View(obj));
}
}
else
{
ViewBag.Visable = false;
ViewBag.Message = "Record Failed To Insert";
return(View(obj));
}
}
