internal LabParameterModel GetParameterByItemId(int itemId)
{
try
{
var data = new LabParameterModel();
Con.Open();
const string query = @"SELECT DefaultResult,Specimen From tbl_LAB_PARAMETER_DEFINITION_FOR_OTHERS WHERE ItemId=@ItemId";
var cmd = new SqlCommand(query, Con);
cmd.Parameters.AddWithValue("@ItemId", itemId);
var rdr = cmd.ExecuteReader();
while (rdr.Read())
{
data.Result = rdr["DefaultResult"].ToString();
data.Specimen = rdr["Specimen"].ToString();
}
rdr.Close();
Con.Close();
return(data);
}
catch (Exception ex)
{
if (Con.State == ConnectionState.Open)
{
Con.Close();
}
throw;
}
}
public async Task <HttpResponseMessage> Post([FromBody] LabParameterModel mLab)
{
var formatter = RequestFormat.JsonFormaterString();
try
{
if (_gt.FncSeekRecordNew("tbl_CLINICAL_CHART", "Id=" + mLab.ItemId + "") == false)
{
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
Output = "error", Msg = "Item Name Is Not Correct"
}, formatter));
}
else
{
string msg = _gt.FncSeekRecordNew("tbl_LAB_PARAMETER_DEFINITION_FOR_OTHERS", "ItemId=" + mLab.ItemId + "") ? await _gt.UpdateOther(mLab) : await _gt.SaveOther(mLab);
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
Output = "success", Msg = msg
}, formatter));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
Output = "error", Msg = ex.ToString()
}, formatter));
}
}
internal Task <string> UpdateOther(LabParameterModel mLab)
{
try
{
Con.Open();
const string query = @"UPDATE tbl_LAB_PARAMETER_DEFINITION_FOR_OTHERS SET DefaultResult=@DefaultResult,UserName=@UserName,Specimen=@Specimen WHERE ItemId=@ItemId";
var cmd = new SqlCommand(query, Con);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@ItemId", mLab.ItemId);
cmd.Parameters.AddWithValue("@DefaultResult", mLab.Result);
cmd.Parameters.AddWithValue("@UserName", mLab.UserName);
cmd.Parameters.AddWithValue("@Specimen", mLab.Specimen);
cmd.ExecuteNonQuery();
Con.Close();
return(Task.FromResult <string>("Saved Success"));
}
catch (Exception ex)
{
if (Con.State == ConnectionState.Open)
{
Con.Close();
}
return(Task.FromResult(ex.Message));
}
}
internal LabParameterModel GetLabdata(int itemId, int invMasterId)
{
try
{
var list = new LabParameterModel();
string query = "SELECT Specimen,Result,ReportDrDetails,LabInchargeDetails,CheckedByDetails,InvoiceNo,InvoiceDate,Age,PtRegNo,Name,MobileNo,InvTime,GenderName,UnderDrName FROM VW_GET_LAB_REPORT_VIEW WHERE ItemId=" + itemId + " AND InvmasTerId=" + invMasterId + "";
Con.Open();
var cmd = new SqlCommand(query, Con);
var rdr = cmd.ExecuteReader();
while (rdr.Read())
{
list.Specimen = rdr["Specimen"].ToString();
list.Result = rdr["Result"].ToString();
list.ReportDrDetails = rdr["ReportDrDetails"].ToString();
list.LabInchargeDetails = rdr["LabInchargeDetails"].ToString();
list.CheckedByDetails = rdr["CheckedByDetails"].ToString();
list.InvoiceNo = rdr["InvoiceNo"].ToString();
list.InvoiceDate = Convert.ToDateTime(rdr["InvoiceDate"]);
list.PtAgeDetail = rdr["Age"].ToString();
list.PtRegNo = rdr["PtRegNo"].ToString();
list.PtName = rdr["Name"].ToString();
list.PtMobileNo = rdr["MobileNo"].ToString();
list.PtGenderName = rdr["GenderName"].ToString();
list.DrName = rdr["UnderDrName"].ToString();
list.InvTime = rdr["InvTime"].ToString();
}
rdr.Close();
Con.Close();
return(list);
}
catch (Exception)
{
throw;
}
}
