public static LaboratoryRequest ViewLaboratoryRequest(int id)
{
LaboratoryRequest request = null;
using (DAL dal = new DAL())
{
try
{
SqlParameter[] spParams =
{
new SqlParameter("@id", id),
};
var data = dal.ExecuteQuery("spViewLaboratoryRequest", spParams).Tables[0];
foreach (DataRow dr in data.AsEnumerable())
{
request = new LaboratoryRequest()
{
id = dr.Field <int>("id"),
type = dr.Field <string>("type"),
typeID = dr.Field <int>("typeID"),
status = dr.Field <string>("status"),
urgency = dr.Field <string>("urgency"),
result = dr.Field <string>("result"),
isPaid = dr.Field <string>("isPaid"),
date = dr.Field <DateTime>("date"),
patient = new Patient()
{
id = dr.Field <string>(16),
firstname = dr.Field <string>(17),
middlename = dr.Field <string>(18),
lastname = dr.Field <string>(19),
gender = char.Parse(dr.Field <string>(20)),
contact = dr.Field <string>(21),
birthdate = dr.Field <DateTime>(22),
address = dr.Field <string>(28)
},
user = new User()
{
id = dr.Field <int>(10),
firstname = dr.Field <string>(13),
lastname = dr.Field <string>(14),
position = dr.Field <string>(15),
}
};
}
return(request);
}
catch (Exception e)
{
return(null);
}
}
}
public static int SaveLaboratoryRequest(LaboratoryRequest request)
{
using (DAL dal = new DAL())
{
SqlParameter[] spParams =
{
new SqlParameter("@doctorID", request.doctorID),
new SqlParameter("@type", request.type),
new SqlParameter("@typeID", request.typeID),
new SqlParameter("@status", request.status),
new SqlParameter("@urgency", request.urgency),
new SqlParameter("@patientID", request.patient.id),
new SqlParameter("@id", (request.id != 0)?request.id:0),
new SqlParameter("@result", request.result),
new SqlParameter("@isPaid", request.isPaid),
new SqlParameter("@date", request.date)
};
return((int)dal.ExecuteQueryScalar("spSaveLabRequest", spParams));
}
}