public bool UpdateMedicineCompany(MedicineCompany medicineCompany)
{
return du.AddRow(@"update MedicineCompany set CompanyID = " + medicineCompany.CompanyID + ")");
}
public bool DeleteMedicineCompany(MedicineCompany medicineCompany)
{
return du.DeleteRow(@"update MedicineCompany set DeleteFlag = 1 where CompanyID ='" + medicineCompany.CompanyID + "')");
}
public bool AddMedicineCompany(MedicineCompany medicineCompany)
{
return du.AddRow(@"insert into MedicineCompany(CompanyID,CompanyCode ,CompanyName, Address1,Address2,Address3,ContactNumber1,ContactNumber2,ContactPerson,Type,UserID,AddDate,ModifiyDate)
values(" + medicineCompany.CompanyID + ",'" + medicineCompany.CompanyCode + "', '" + medicineCompany.CompanyName + "', " + medicineCompany.Address1 + ", '" + medicineCompany.Address2 + "', '" + medicineCompany.Address3 + "', '" + medicineCompany.ContactNumber1 + "', '" + medicineCompany.ContactNumber2 + "', '" + medicineCompany.ContactPerson + "', '" + medicineCompany.Type + "', '" + medicineCompany.UserID + "', '" + medicineCompany.AddDate + "', '" + medicineCompany.ModifiyDate + "')");
}