public DataSet SelectAll(Company company) { Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING); DbCommand dbCommand = db.GetStoredProcCommand("usp_CompanySelectAll"); return db.ExecuteDataSet(dbCommand); }
public bool Update(Company company) { Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING); DbCommand command = db.GetStoredProcCommand("usp_CompanyUpdate"); db.AddInParameter(command, "@CompanyId", DbType.Int32, company.CompanyId); db.AddInParameter(command, "@CompanyName", DbType.String, company.CompanyName); db.AddInParameter(command, "@CompanyAddress", DbType.String, company.CompanyAddress); db.AddInParameter(command, "@CompanyCity", DbType.String, company.CompanyCity); db.AddInParameter(command, "@CompanyEmail", DbType.String, company.CompanyEmail); db.AddInParameter(command, "@CompanyTelephone", DbType.String, company.CompanyTelephone); db.AddInParameter(command, "@UpdatedUser", DbType.Int32, company.UpdatedUser); db.AddInParameter(command, "@StatusId", DbType.Int32, company.StatusId); db.AddInParameter(command, "@CompanyFax", DbType.String, company.CompanyFax); db.AddInParameter(command, "@CompanyLogo", DbType.Binary, company.CompanyLogo); db.AddInParameter(command, "@WebURL", DbType.String, company.WebURL); db.AddInParameter(command, "@RegistrationNo", DbType.String, company.RegistrationNo); db.AddInParameter(command, "@VATNo", DbType.String, company.VATNo); db.AddInParameter(command, "@AdditionalDetails1", DbType.String, company.AdditionalDetails1); db.AddInParameter(command, "@AdditionalDetails2", DbType.String, company.AdditionalDetails2); db.ExecuteNonQuery(command); return true; }
public bool Delete(Company company) { Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING); DbCommand command = db.GetStoredProcCommand("usp_CompanyDelete"); db.AddInParameter(command, "@CompanyId", DbType.Int32, company.CompanyId); db.ExecuteNonQuery(command); return true; }