public static ResponseAttachmentsList GetAllAttachments(string identification) { List <AttachmentsModel> attachments = new List <AttachmentsModel>(); using (MySqlConnection conn = ConecctionModel.conn) { conn.Open(); string SP = AppManagement.SP_GetAll_Attachments; MySqlCommand cmd = new MySqlCommand(SP, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@pidentification", identification); MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { AttachmentsModel attachment = new AttachmentsModel(); attachment.Identification = rdr["id_patient"].ToString(); attachment.FileName = rdr["file_name"].ToString(); attachment.Content = rdr["content"].ToString(); attachment.Extension = rdr["extension"].ToString(); attachment.Description = rdr["description"].ToString(); attachments.Add(attachment); } rdr.Close(); return(new ResponseAttachmentsList { IsSuccessful = true, ResponseMessage = AppManagement.MSG_GetAllAttachments_Success, ResponseAttachments = attachments }); } }
public static Response DeleteAttachment(AttachmentsModel attachment) { using (MySqlConnection conn = ConecctionModel.conn) { conn.Open(); string SP = AppManagement.SP_Delete_Attachments; MySqlCommand cmd = new MySqlCommand(SP, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@pidentification", attachment.Identification); cmd.Parameters.AddWithValue("@pfilename", attachment.FileName); MySqlDataReader rdr = cmd.ExecuteReader(); rdr.Close(); if (rdr.RecordsAffected != 0) { return new Response { IsSuccessful = true, ResponseMessage = AppManagement.MSG_DeleteAttachment_Success } } ; return(new Response { IsSuccessful = false, ResponseMessage = AppManagement.MSG_DeleteAttachment_Failure }); } } #endregion }
public static ResponsePatient GetPatient(string identification) { PatientModel patient = null; using (MySqlConnection conn = ConecctionModel.conn) { conn.Open(); string SP = AppManagement.SP_GetPatient; MySqlCommand cmd = new MySqlCommand(SP, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@p_id_patient", identification); using (MySqlDataReader rdr = cmd.ExecuteReader()) { if (rdr.Read()) { patient = new PatientModel() { Identification = rdr["id_patient"].ToString(), IdParent = rdr["id_parent"].ToString(), Name = rdr["name"].ToString(), BirthDate = Convert.ToDateTime(rdr["birth_date"]), Age = Convert.ToInt32(rdr["age"]), Ethnic = new EthnicModel() { Id = Convert.ToInt32(rdr["id_ethnic_group"]), Name = rdr["ethnic_name"].ToString() }, Gender = rdr["gender"].ToString() }; } } } if (patient.IsNotNull()) { patient.Treatments = PatientTreatmentDeseaseModel.GetAllTreatmentDeseasest(patient.Identification).PatientTreatmentDeseases; patient.Attachments = AttachmentsModel.GetAllAttachments(patient.Identification).ResponseAttachments; patient.Cases = PatientCaseModel.GetAllPatientCases(patient.Identification).PatientCases; } return(new ResponsePatient { IsSuccessful = true, ResponseMessage = AppManagement.MSG_GetPatient_Success, Patient = patient }); }
public static Response SaveAttachment(AttachmentsModel attachments) { 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", attachments.Identification); cmd.Parameters.AddWithValue("@pfilename", attachments.FileName); cmd.Parameters.AddWithValue("@pcontent", attachments.Content); cmd.Parameters.AddWithValue("@pextension", attachments.Extension); cmd.Parameters.AddWithValue("@pdescription", attachments.Description); MySqlParameter NroIdInvoice = new MySqlParameter("@result", idresult); NroIdInvoice.Direction = ParameterDirection.Output; cmd.Parameters.Add(NroIdInvoice); cmd.ExecuteNonQuery(); idresult = Int32.Parse(cmd.Parameters["@result"].Value.ToString()); if (idresult != 0) { if (idresult == 1)//mas de 20 archivos { return new Response { IsSuccessful = false, ResponseMessage = AppManagement.MSG_SaveAttachment_Failure20 } } ; else { return new Response { IsSuccessful = false, ResponseMessage = AppManagement.MSG_SaveAttachment_FailureDefault } }; } else { return new Response { IsSuccessful = true, ResponseMessage = AppManagement.MSG_SaveAttachment_Success } }; } } catch (Exception ex) { return(new Response { IsSuccessful = false, ResponseMessage = AppManagement.MSG_SaveAttachment_FailureDefault }); } }