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