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