/// <summary>
/// Creates and returns an <see cref="System.Data.IDbCommand"/> object that is used
/// to retrieve all records from the <c>lkpCasepriority</c> table.
/// </summary>
/// <returns>A reference to the <see cref="System.Data.IDbCommand"/> object.</returns>
protected virtual IDbCommand CreateGetAllCommand()
{
return(_db.CreateCommand("dbo._lkpCasepriority_GetAll", true));
}
/// <summary>
/// Creates and returns an <see cref="System.Data.IDbCommand"/> object that is used
/// to retrieve all records from the <c>tblRecentLog</c> table.
/// </summary>
/// <returns>A reference to the <see cref="System.Data.IDbCommand"/> object.</returns>
protected virtual IDbCommand CreateGetAllCommand()
{
return(_db.CreateCommand("dbo._tblRecentLog_GetAll", true));
}
/// <summary>
/// Creates and returns an <see cref="System.Data.IDbCommand"/> object that is used
/// to retrieve all records from the <c>lkpGenders</c> table.
/// </summary>
/// <returns>A reference to the <see cref="System.Data.IDbCommand"/> object.</returns>
protected virtual IDbCommand CreateGetAllCommand()
{
return(_db.CreateCommand("dbo._lkpGenders_GetAll", true));
}
/// <summary>
/// Creates and returns an <see cref="System.Data.IDbCommand"/> object that is used
/// to retrieve all records from the <c>aspnet_PersonalizationPerUser</c> table.
/// </summary>
/// <returns>A reference to the <see cref="System.Data.IDbCommand"/> object.</returns>
protected virtual IDbCommand CreateGetAllCommand()
{
return(_db.CreateCommand("dbo._aspnet_PersonalizationPerUser_GetAll", true));
}
/// <summary>
/// Creates and returns an <see cref="System.Data.IDbCommand"/> object that is used
/// to retrieve all records from the <c>aspnet_Applications</c> table.
/// </summary>
/// <returns>A reference to the <see cref="System.Data.IDbCommand"/> object.</returns>
protected virtual IDbCommand CreateGetAllCommand()
{
return(_db.CreateCommand("dbo._aspnet_Applications_GetAll", true));
}
/// <summary>
/// Creates and returns an <see cref="System.Data.IDbCommand"/> object that is used
/// to retrieve all records from the <c>aspnet_SchemaVersions</c> table.
/// </summary>
/// <returns>A reference to the <see cref="System.Data.IDbCommand"/> object.</returns>
protected virtual IDbCommand CreateGetAllCommand()
{
return(_db.CreateCommand("dbo._aspnet_SchemaVersions_GetAll", true));
}
public Int32 getMaxCaseNo(int ProvID)
{
DataTable dtCaseNo = new DataTable();
SqlCommand cmdSelect = ((SqlCommand)objDB.CreateCommand("_CaseCount", true));
cmdSelect.Parameters.Add("@provID", SqlDbType.Int).Value = ProvID;
dtCaseNo = objDB.CreateDataTable(cmdSelect);
return(Convert.ToInt32(dtCaseNo.Rows[0][0]));
}
/// <summary>
/// Creates and returns an <see cref="System.Data.IDbCommand"/> object that is used
/// to retrieve all records from the <c>aspnet_WebEvent_Events</c> table.
/// </summary>
/// <returns>A reference to the <see cref="System.Data.IDbCommand"/> object.</returns>
protected virtual IDbCommand CreateGetAllCommand()
{
return(_db.CreateCommand("dbo._aspnet_WebEvent_Events_GetAll", true));
}
/// <summary>
/// Creates and returns an <see cref="System.Data.IDbCommand"/> object that is used
/// to retrieve all records from the <c>lkpResponsibleOffice</c> table.
/// </summary>
/// <returns>A reference to the <see cref="System.Data.IDbCommand"/> object.</returns>
protected virtual IDbCommand CreateGetAllCommand()
{
return(_db.CreateCommand("dbo._lkpResponsibleOffice_GetAll", true));
}
/// <summary>
/// Creates and returns an <see cref="System.Data.IDbCommand"/> object that is used
/// to retrieve all records from the <c>lkpComplainanttype</c> table.
/// </summary>
/// <returns>A reference to the <see cref="System.Data.IDbCommand"/> object.</returns>
protected virtual IDbCommand CreateGetAllCommand()
{
return(_db.CreateCommand("dbo._lkpComplainanttype_GetAll", true));
}
/// <summary>
/// Creates and returns an <see cref="System.Data.IDbCommand"/> object that is used
/// to retrieve all records from the <c>aspnet_UsersInRoles</c> table.
/// </summary>
/// <returns>A reference to the <see cref="System.Data.IDbCommand"/> object.</returns>
protected virtual IDbCommand CreateGetAllCommand()
{
return(_db.CreateCommand("dbo._aspnet_UsersInRoles_GetAll", true));
}
/// <summary>
/// Creates and returns an <see cref="System.Data.IDbCommand"/> object that is used
/// to retrieve all records from the <c>aspnet_Profile</c> table.
/// </summary>
/// <returns>A reference to the <see cref="System.Data.IDbCommand"/> object.</returns>
protected virtual IDbCommand CreateGetAllCommand()
{
return(_db.CreateCommand("dbo._aspnet_Profile_GetAll", true));
}
/// <summary>
/// Creates and returns an <see cref="System.Data.IDbCommand"/> object that is used
/// to retrieve all records from the <c>lkpAllegationtype</c> table.
/// </summary>
/// <returns>A reference to the <see cref="System.Data.IDbCommand"/> object.</returns>
protected virtual IDbCommand CreateGetAllCommand()
{
return(_db.CreateCommand("dbo._lkpAllegationtype_GetAll", true));
}
/// <summary>
/// Creates and returns an <see cref="System.Data.IDbCommand"/> object that is used
/// to retrieve all records from the <c>lkpPollingCenter</c> table.
/// </summary>
/// <returns>A reference to the <see cref="System.Data.IDbCommand"/> object.</returns>
protected virtual IDbCommand CreateGetAllCommand()
{
return(_db.CreateCommand("dbo._lkpPollingCenter_GetAll", true));
}