public void addMedicine(string meds) { if (!GlobalComponents.IsEmptyText(meds)) { if (!medicalValidation(meds)) { try { DataProcessor.getStreamOn(); cmdExec = DataProcessor.execCommand(sqlAdd(meds)); cmdExec.ExecuteNonQuery(); MessageBox.Show($"Medicamento ingresado con Exito"); } catch (Exception e) { GlobalComponents.InsertError(e); } finally { DataProcessor.getStreamOff(); } } else { MessageBox.Show($"Ya existe un codigo similar en el catalogo"); } } else { MessageBox.Show($"Todos los campos son obligatorios"); } }
private string medicalChainString() { string medicineValues; string text1 = (!GlobalComponents.IsEmptyText(this.barCode.Text))? this.barCode.Text :null; string text2 = (!GlobalComponents.IsEmptyText(this.textBox1.Text)) ? this.textBox1.Text : null; string text3 = (!GlobalComponents.IsEmptyText(this.textBox2.Text)) ? this.textBox2.Text : null; string text4 = (!GlobalComponents.IsEmptyText(this.textBox3.Text)) ? this.textBox3.Text : null; string date = (this.dateTimePicker2.Value.Date > DateTime.Now.Date)? $"{(this.dateTimePicker2.Value):yyyy/MM/dd}": null; string text5 = (!GlobalComponents.IsEmptyText(this.textBox4.Text)) ? this.textBox4.Text : null; string text6 = (!GlobalComponents.IsEmptyText(this.textBox5.Text)) ? this.textBox5.Text : null; string text7 = (!GlobalComponents.IsEmptyText(this.textBox6.Text)) ? this.textBox6.Text : null; string text8 = (!GlobalComponents.IsEmptyText(this.textBox7.Text)) ? this.textBox7.Text : null; if (text1 == null || text2 == null || text3 == null || date == null || text4 == null || text5 == null || text6 == null || text7 == null || text8 == null) { medicineValues = ""; } else { medicineValues = $"{this.barCode.Text},'{this.textBox1.Text}','{this.textBox2.Text}','{this.textBox3.Text}'," + $"'{(this.dateTimePicker2.Value):yyyy/MM/dd}',{this.textBox4.Text},'{ this.textBox5.Text}'," + $"{this.textBox6.Text },{this.textBox7.Text}," + $"'{DateTime.Now:yyy/MM/dd HH:mm}','{GlobalComponents.getSessionId}'," + $"{((this.radioButton1.Checked) ? "1" : "0")}"; } return(medicineValues); }
public void delMedicine(string code) { if (!GlobalComponents.IsEmptyText(code)) { ///TODO ///hay que agregar una validacion, si hay existencias no se puede eliminar int barcode = int.Parse(code); try { DialogResult a = MessageBox.Show("El elemento se eliminara de manera definitiva \n ¿desea continuar?", "Alerta", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); if (a == DialogResult.OK) { DataProcessor.getStreamOn(); cmdExec = DataProcessor.execCommand(this.sqlDel(barcode)); cmdExec.ExecuteNonQuery(); MessageBox.Show("Se elimino el registro"); } } catch (Exception e) { GlobalComponents.InsertError(e); } finally { DataProcessor.getStreamOff(); } } else { MessageBox.Show($"El codigo del medicamento es obligatorio"); } }