public DataSet SelectAll(AdditionalServiceType additionalServiceType) { Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING); DbCommand dbCommand = db.GetStoredProcCommand("usp_AdditionalServiceTypeSelectAll"); db.AddInParameter(dbCommand, "@CompanyId", DbType.Int32, additionalServiceType.CompanyId); return db.ExecuteDataSet(dbCommand); }
public DataSet SelectAll(AdditionalServiceType additionalServiceType) { Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING); DbCommand dbCommand = db.GetStoredProcCommand("usp_AdditionalServiceTypeSelectAll"); db.AddInParameter(dbCommand, "@CompanyId", DbType.Int32, additionalServiceType.CompanyId); return(db.ExecuteDataSet(dbCommand)); }
public bool IsDuplicateTypeName(AdditionalServiceType additionalServiceType) { bool result=false; Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING); DbCommand dbCommand = db.GetStoredProcCommand("usp_AdditionalServiceTypeIsDuplicateTypeName"); db.AddInParameter(dbCommand, "@CompanyId", DbType.Int32, additionalServiceType.CompanyId); db.AddInParameter(dbCommand, "@AdditionalServiceTypeId", DbType.Int32, additionalServiceType.AdditionalServiceTypeId); db.AddInParameter(dbCommand, "@AdditionalServiceType", DbType.String, additionalServiceType.AdditionalServiceTypeName); db.AddOutParameter(dbCommand, "@IsExist", DbType.Boolean, 1); db.ExecuteNonQuery(dbCommand); result = Convert.ToBoolean(db.GetParameterValue(dbCommand, "@IsExist").ToString()); return result; }
public bool IsDuplicateTypeName(AdditionalServiceType additionalServiceType) { bool result = false; Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING); DbCommand dbCommand = db.GetStoredProcCommand("usp_AdditionalServiceTypeIsDuplicateTypeName"); db.AddInParameter(dbCommand, "@CompanyId", DbType.Int32, additionalServiceType.CompanyId); db.AddInParameter(dbCommand, "@AdditionalServiceTypeId", DbType.Int32, additionalServiceType.AdditionalServiceTypeId); db.AddInParameter(dbCommand, "@AdditionalServiceType", DbType.String, additionalServiceType.AdditionalServiceTypeName); db.AddOutParameter(dbCommand, "@IsExist", DbType.Boolean, 1); db.ExecuteNonQuery(dbCommand); result = Convert.ToBoolean(db.GetParameterValue(dbCommand, "@IsExist").ToString()); return(result); }