public void DeleteMedicine(MedicineInfo obj)
{
string Qry = "DELETE FROM MedicineInfo WHERE MedicineID='" + obj.MedicineID + "'";
DbUtility.ExecuteQuery(Qry);
}
public void UpdateMedicine(MedicineInfo obj)
{
string Qry = "update MedicineInfo set MedicineName='" + obj.MedicineBrandName + "',[Contains]='" + obj.Contains + "',DosageId='" + obj.Dosage + "',Manufacturer='" + obj.Manufacturar + "',Price='" + obj.Price + "' where MedicineID='" + obj.MedicineID + "'";
DbUtility.ExecuteQuery(Qry);
}
private void btnupdate_Click(object sender, EventArgs e)
{
obj = new MedicineInfo();
obj.MedicineID = txtID.Text;
obj.MedicineBrandName = txtName.Text;
obj.Contains = txtContains.Text;
obj.Manufacturar = cmbPharma.SelectedValue.ToString();
obj.Dosage = cmbDosage.SelectedValue.ToString();
obj.Price = Convert.ToDecimal(txtPrice.Text);
MedicineInfoBLL bllObj = new MedicineInfoBLL();
bllObj.UpdateMedicine(obj);
MessageBox.Show("Data Updated Successfully");
this.LoadMedicine();
}
private void loadTOModel()
{
obj=new MedicineInfo();
obj.MedicineID = txtID.Text;
obj.MedicineBrandName = txtName.Text;
obj.Contains = txtContains.Text;
obj.Manufacturar = cmbPharma.SelectedValue.ToString();
obj.Dosage = cmbDosage.SelectedValue.ToString();
obj.Price = Convert.ToDecimal(txtPrice.Text);
MedicineInfoBLL bllObj=new MedicineInfoBLL();
bllObj.SaveMedicine(obj);
MessageBox.Show("Data successfully Saved!");
this.LoadMedicine();
}
public void DeleteMedicine(MedicineInfo obj)
{
dalObj=new MedicineDAL();
dalObj.DeleteMedicine(obj);
}
public void UpdateMedicine(MedicineInfo obj)
{
dalObj=new MedicineDAL();
dalObj.UpdateMedicine(obj);
}
public void SaveMedicine(MedicineInfo obj)
{
dalObj=new MedicineDAL();
dalObj.SaveMedicine(obj);
}
public void SaveMedicine(MedicineInfo obj)
{
string Qry = "INSERT INTO [CureDB].[dbo].[MedicineInfo]([MedicineID],[MedicineName],[Contains],[DosageId],[Manufacturer],[Price])VALUES('"+obj.MedicineID+"','"+obj.MedicineBrandName+"','"+obj.Contains+"','"+obj.Dosage+"','"+obj.Manufacturar+"',"+obj.Price+") ";
DbUtility.ExecuteQuery(Qry);
}
private void dgvInfo_MouseDoubleClick(object sender, MouseEventArgs e)
{
obj = new MedicineInfo();
obj.MedicineID = txtID.Text;
obj.MedicineBrandName = txtName.Text;
obj.Contains = txtContains.Text;
obj.Manufacturar = cmbPharma.SelectedValue.ToString();
obj.Dosage = cmbDosage.SelectedValue.ToString();
// obj.Price = Convert.ToDecimal(txtPrice.Text);
obj.MedicineID = dgvInfo.SelectedRows[0].Cells[0].Value.ToString();
obj.MedicineID = dgvInfo.SelectedRows[0].Cells[1].Value.ToString();
obj.Contains = dgvInfo.SelectedRows[0].Cells[2].Value.ToString();
obj.Dosage = dgvInfo.SelectedRows[0].Cells[3].Value.ToString();
obj.Manufacturar = dgvInfo.SelectedRows[0].Cells[4].Value.ToString();
obj.Price = Convert.ToDecimal(dgvInfo.SelectedRows[0].Cells[5].Value.ToString());
}
