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()); }