public void updateMedicine(medicine modified)
{
medicine currentMed = hms.medicines.Where(x => x.mid == modified.mid).FirstOrDefault();
hms.Entry(currentMed).CurrentValues.SetValues(modified);
hms.SaveChanges();
}
public void id()
{
medicine med = new medicine();
med.loadID();
textBox2.Text = "M" + med.count;
}
public void remove(medicine med)
{
medicine m = hms.medicines.Where(x => x.mid == med.mid).FirstOrDefault();
hms.medicines.Remove(m);
hms.SaveChanges();
}
private void fullMedicineList()
{
medicine med = new medicine();
med.fullMedicineList();
dataGridView1.DataSource = med.table;
}
public async Task <IActionResult> Putmedicine(int id, medicine medicine)
{
if (id != medicine.MedicineId)
{
return(BadRequest());
}
_context.Entry(medicine).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!medicineExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
private void button2_Click(object sender, EventArgs e)
{
if (textBox5.Text != "")
{
if (textBox4.Text != "" && Convert.ToInt32(textBox4.Text) != 0)
{
medicine med = new medicine();
if (dataGridView1.Rows.Count == 0)
{
med.generateStoreIndentNo();
}
med.generateStoreIndent(textBox5.Text, textBox2.Text, textBox4.Text, textBox3.Text, username);
indentLoad();
clear();
}
else
{
MessageBox.Show("Please enter Valid Quantity!!");
}
}
else
{
MessageBox.Show("Please Select a Medicine!!");
}
}
/**
* GET request that get one medicine
*/
public medicine GetMedicineById(int id)
{
var query = "SELECT * FROM getmedicine(" + id + ");";
medicine med = _context.Database.SqlQuery <medicine>(query).FirstOrDefault();
return(med);
}
public async Task <ActionResult <medicine> > Postmedicine(medicine medicine)
{
_context.medicines.Add(medicine);
await _context.SaveChangesAsync();
return(CreatedAtAction("Getmedicine", new { id = medicine.MedicineId }, medicine));
}
public medicine Insert_medicine_select(int ID)
{
medicine = medicine.Select(ID);
Insert_Medication_type_txt.Text = Convert.ToString(medicine.Medication_type);
Insert_Medication_name_txt.Text = Convert.ToString(medicine.Medication_name);
Insert_Clients_Served_txt.Text = Convert.ToString(medicine.Clients_Served);
return(medicine);
}
public medicine Insert_medicine_select(int ID)
{
medicine = medicine.Select(ID);
Insert_Medication_type_txt.Text = Convert.ToString(medicine.Medication_type);
Insert_Medication_name_txt.Text = Convert.ToString(medicine.Medication_name);
Insert_Clients_Served_txt.Text = Convert.ToString(medicine.Clients_Served);
return medicine;
}
public void medicinesLoad(string like)
{
medicine med = new medicine();
med.loadMedicineDisp(like);
dataGridView1.DataSource = med.table;
dataGridView1.ClearSelection();
}
public void medicinesLoad()
{
medicine med = new medicine();
med.loadMedicineDisp();
dataGridView2.DataSource = med.table;
dataGridView2.ClearSelection();
}
public ActionResult DeleteConfirmed(int id)
{
medicine medicine = db.medicines.Find(id);
db.medicines.Remove(medicine);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void medicinesLoad()
{
medicine med = new medicine();
med.loadMedicineDisp();
dataGridView1.DataSource = med.table;
dataGridView1.ClearSelection();
textBox2.Text = dataGridView1.Rows.Count.ToString();
}
public void indentLoad()
{
medicine med = new medicine();
med.loadDispIndent();
dataGridView1.DataSource = med.table;
dataGridView1.ClearSelection();
textBox7.Text = dataGridView1.Rows.Count.ToString();
}
public medicine Delete_medicine_select(int ID)
{
medicine = medicine.Select(ID);
Delete_Medicine_Id_txt_lbl.Text = Convert.ToString(medicine.Medicine_Id);
Delete_Medication_type_txt_lbl.Text = Convert.ToString(medicine.Medication_type);
Delete_Medication_name_txt_lbl.Text = Convert.ToString(medicine.Medication_name);
Delete_Clients_Served_txt_lbl.Text = Convert.ToString(medicine.Clients_Served);
return(medicine);
}
public medicine Delete_medicine_select(int ID)
{
medicine = medicine.Select(ID);
Delete_Medicine_Id_txt_lbl.Text = Convert.ToString(medicine.Medicine_Id);
Delete_Medication_type_txt_lbl.Text = Convert.ToString(medicine.Medication_type);
Delete_Medication_name_txt_lbl.Text = Convert.ToString(medicine.Medication_name);
Delete_Clients_Served_txt_lbl.Text = Convert.ToString(medicine.Clients_Served);
return medicine;
}
public ActionResult Edit([Bind(Include = "id,name,quantity,price")] medicine medicine)
{
if (ModelState.IsValid)
{
db.Entry(medicine).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(medicine));
}
public medicine medicine_insert()
{
medicine.Medication_type = Insert_Medication_type_txt.Text;
medicine.Medication_name = Insert_Medication_name_txt.Text;
medicine.Clients_Served = Convert.ToInt32(Insert_Clients_Served_txt.Text);
medicine = medicine.Insert(medicine);
Insert_medicine_GridView.DataBind();
Update_medicine_GridView.DataBind();
Delete_medicine_GridView.DataBind();
return medicine;
}
public static ReceptionMedicineVM ReceptionMedicineTransform(medicine medicine)
{
return(new ReceptionMedicineVM
{
Id = medicine.id,
Name = medicine.medicine_name,
Quantity = medicine.quantity_in_sale_unit.ToString(),
SalePrice = medicine.sale_price_per_unit.ToString(),
Unit = medicine.sale_unit
});
}
public void indentLoad()
{
medicine med = new medicine();
med.loadStoreIndent();
dataGridView1.DataSource = med.table;
dataGridView1.ClearSelection();
textBox7.Text = dataGridView1.Rows.Count.ToString();
med.getStoreIndentNo(textBox6.Text);
textBox8.Text = med.count;
}
public void totalTransfer(string id)
{
medicine med = new medicine();
med.countQty("opening", id, "store");
textBox8.Text = med.count.ToString();
med.countQty("received", id, "store");
textBox9.Text = med.count.ToString();
med.countQty("sent", id, "store");
textBox10.Text = med.count.ToString();
}
public ActionResult Create([Bind(Include = "id,name,quantity,price")] medicine medicine)
{
if (ModelState.IsValid)
{
db.medicines.Add(medicine);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(medicine));
}
public medicine medicine_insert()
{
medicine.Medication_type = Insert_Medication_type_txt.Text;
medicine.Medication_name = Insert_Medication_name_txt.Text;
medicine.Clients_Served = Convert.ToInt32(Insert_Clients_Served_txt.Text);
medicine = medicine.Insert(medicine);
Insert_medicine_GridView.DataBind();
Update_medicine_GridView.DataBind();
Delete_medicine_GridView.DataBind();
return(medicine);
}
private ReceptionMedicineVM GetViewModel(medicine medicine)
{
return(new ReceptionMedicineVM
{
Id = medicine.id,
Name = medicine.medicine_name,
Quantity = medicine.quantity_in_sale_unit.ToString(),
SalePrice = medicine.sale_price_per_unit.ToString(),
Unit = medicine.sale_unit
});
}
public void loadMedicines(string like)
{
medicine med = new medicine();
med.listMedicine(like);
listBox1.DataSource = med.table;
listBox1.ValueMember = "medicine_id";
listBox1.DisplayMember = "medicineDetail";
listBox1.BindingContext = new BindingContext();
listBox1.SelectedIndex = -1;
}
public void loadMedicines(string like)
{
medicine med = new medicine();
med.loadMedicine(like);
dataGridView1.DataSource = med.table;
dataGridView1.ClearSelection();
foreach (DataGridViewColumn column in dataGridView1.Columns)
{
column.SortMode = DataGridViewColumnSortMode.NotSortable;
}
}
public void loadIndent(string indentNo)
{
medicine med = new medicine();
med.loadDispIndentIssued(indentNo);
dataGridView1.DataSource = med.table;
dataGridView1.ClearSelection();
foreach (DataGridViewColumn column in dataGridView1.Columns)
{
column.SortMode = DataGridViewColumnSortMode.NotSortable;
}
}
private MedicineAssignedVM GetMedicineViewModel(prescription prescriptionItem)
{
medicine med = _medicineRepository.GetMedicineById(prescriptionItem.medicine_id);
return(new MedicineAssignedVM()
{
Name = med.medicine_name,
Description = prescriptionItem.description,
Quantity = prescriptionItem.quantity_indicated.ToString(),
SalePrice = med.sale_price_per_unit.ToString(),
Unit = med.sale_unit
});
}
public medicine medicine_update(int ID)
{
medicine = medicine.Select(ID);
medicine.Medicine_Id = Convert.ToInt32(Update_Medicine_Id_txt.Text);
medicine.Medication_type = Update_Medication_type_txt.Text;
medicine.Medication_name = Update_Medication_name_txt.Text;
medicine.Clients_Served = Convert.ToInt32(Update_Clients_Served_txt.Text);
medicine.Update(medicine);
Insert_medicine_GridView.DataBind();
Update_medicine_GridView.DataBind();
Delete_medicine_GridView.DataBind();
return(medicine);
}
public void loadMedicines()
{
medicine med = new medicine();
med.listMedicine();
listBox1.DataSource = med.table;
listBox1.ValueMember = "medicine_id";
listBox1.DisplayMember = "medicineDetail";
listBox1.BindingContext = new BindingContext();
listBox1.SelectedIndex = -1;
med.loadID();
textBox4.Text = (Convert.ToInt32(med.count) - 1).ToString();
}
public ActionResult DeleteConfirmed(Guid id)
{
if (!HomeController.Authorized(this))
{
return(RedirectToAction("Login", "Accounts"));
}
medicine medicine = db.medicines.Find(id);
Guid prescId = (Guid)medicine.prescriptionId;
db.medicines.Remove(medicine);
db.SaveChanges();
return(RedirectToAction("Index", new { @id = prescId }));
}
public void Add_WithValidInput_AddSuccessfully()
{
medicine medicineInserted = null;
_mockMedicineRepo.Setup(m => m.Insert(It.IsAny <medicine>())).Callback <medicine>(medicine =>
medicineInserted = medicine
);
_sut.Add();
_mockMedicineRepo.Verify(m => m.Insert(medicineInserted));
medicineInserted.Should().BeEquivalentTo(_stubMedicine);
}
protected void INSERT(object sender, EventArgs e)
{
medicine = medicine_insert();
}
protected void Insert_Select_Record(object sender, EventArgs e)
{
medicine = Insert_medicine_select(Convert.ToInt32(Insert_medicine_GridView.SelectedValue));
}
protected void UPDATE(object sender, EventArgs e)
{
medicine = medicine_update(Convert.ToInt32(Update_medicine_GridView.SelectedValue));
}
protected void Update_Select_Record(object sender, EventArgs e)
{
medicine = Update_medicine_select(Convert.ToInt32(Update_medicine_GridView.SelectedValue));
}
public medicine medicine_update(int ID)
{
medicine = medicine.Select(ID);
medicine.Medicine_Id = Convert.ToInt32(Update_Medicine_Id_txt.Text);
medicine.Medication_type = Update_Medication_type_txt.Text;
medicine.Medication_name = Update_Medication_name_txt.Text;
medicine.Clients_Served = Convert.ToInt32(Update_Clients_Served_txt.Text);
medicine.Update(medicine);
Insert_medicine_GridView.DataBind();
Update_medicine_GridView.DataBind();
Delete_medicine_GridView.DataBind();
return medicine;
}
