public static Response SaveAttachment(PatientHistoryModel history)
{
try
{
using (MySqlConnection conn = ConecctionModel.conn)
{
conn.Open();
int idresult = 0;
string SP = AppManagement.SP_Save_Patient_Attachments;
MySqlCommand cmd = new MySqlCommand(SP, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@pidentification", history.Identification);
cmd.Parameters.AddWithValue("@pnote", history.Note);
cmd.Parameters.AddWithValue("@pphoto", history.Photo);
cmd.ExecuteNonQuery();
return(new Response {
IsSuccessful = true, ResponseMessage = AppManagement.MSG_SaveAttachment_Success
});
}
}
catch (Exception ex)
{
return(new Response {
IsSuccessful = false, ResponseMessage = AppManagement.MSG_SaveAttachment_FailureDefault
});
}
}
public static ResponseHistoriesList GetAllHistories(PatientHistoryModel history)
{
List <PatientHistoryModel> histories = new List <PatientHistoryModel>();
using (MySqlConnection conn = ConecctionModel.conn)
{
conn.Open();
string SP = AppManagement.SP_GetAll_Histories;
MySqlCommand cmd = new MySqlCommand(SP, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@pidentification", history.Identification);
cmd.Parameters.AddWithValue("@pDate", history.Date);
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
PatientHistoryModel _history = new PatientHistoryModel();
_history.IdHistory = Convert.ToInt32(rdr["id_history"].ToString());
_history.Identification = rdr["id_patient"].ToString();
_history.Note = rdr["note"].ToString();
if (!(rdr["date"] is DBNull))
{
_history.Date = Convert.ToDateTime(rdr["date"]);
}
_history.Photo = rdr["photo"].ToString();
histories.Add(_history);
}
rdr.Close();
return(new ResponseHistoriesList {
IsSuccessful = true, ResponseMessage = AppManagement.MSG_GetAllHistories_Success, ResponseHistories = histories
});
}
}
