/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Id":
parameter = _db.AddParameter(cmd, paramName, DbType.Guid, value);
break;
case "PathId":
parameter = _db.AddParameter(cmd, paramName, DbType.Guid, value);
break;
case "UserId":
parameter = _db.AddParameter(cmd, paramName, DbType.Guid, value);
break;
case "PageSettings":
parameter = _db.AddParameter(cmd, paramName, DbType.Binary, value);
break;
case "LastUpdatedDate":
parameter = _db.AddParameter(cmd, paramName, DbType.DateTime, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "ApplicationName":
parameter = _db.AddParameter(cmd, paramName, DbType.String, value);
break;
case "LoweredApplicationName":
parameter = _db.AddParameter(cmd, paramName, DbType.String, value);
break;
case "ApplicationId":
parameter = _db.AddParameter(cmd, paramName, DbType.Guid, value);
break;
case "Description":
parameter = _db.AddParameter(cmd, paramName, DbType.String, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "District_Id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "District_Name":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "District_Dari":
parameter = _db.AddParameter(cmd, paramName, DbType.String, value);
break;
case "District_Code":
parameter = _db.AddParameter(cmd, paramName, DbType.StringFixedLength, value);
break;
case "Province_Id":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "CaseProID":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "CaseProName":
parameter = _db.AddParameter(cmd, paramName, DbType.String, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Feature":
parameter = _db.AddParameter(cmd, paramName, DbType.String, value);
break;
case "CompatibleSchemaVersion":
parameter = _db.AddParameter(cmd, paramName, DbType.String, value);
break;
case "IsCurrentVersion":
parameter = _db.AddParameter(cmd, paramName, DbType.Boolean, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "ApplicationId":
parameter = _db.AddParameter(cmd, paramName, DbType.Guid, value);
break;
case "UserId":
parameter = _db.AddParameter(cmd, paramName, DbType.Guid, value);
break;
case "UserName":
parameter = _db.AddParameter(cmd, paramName, DbType.String, value);
break;
case "LoweredUserName":
parameter = _db.AddParameter(cmd, paramName, DbType.String, value);
break;
case "MobileAlias":
parameter = _db.AddParameter(cmd, paramName, DbType.String, value);
break;
case "IsAnonymous":
parameter = _db.AddParameter(cmd, paramName, DbType.Boolean, value);
break;
case "LastActivityDate":
parameter = _db.AddParameter(cmd, paramName, DbType.DateTime, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "Cand_ID":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Cand_No":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiString, value);
break;
case "Cand_Name":
parameter = _db.AddParameter(cmd, paramName, DbType.String, value);
break;
case "Cand_FName":
parameter = _db.AddParameter(cmd, paramName, DbType.String, value);
break;
case "GenderID":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Prov_ID":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "IsDeleted":
parameter = _db.AddParameter(cmd, paramName, DbType.Boolean, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
/// <summary>
/// Adds a new parameter to the specified command.
/// </summary>
/// <param name="cmd">The <see cref="System.Data.IDbCommand"/> object to add the parameter to.</param>
/// <param name="paramName">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <returns>A reference to the added parameter.</returns>
protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value)
{
IDbDataParameter parameter;
switch (paramName)
{
case "EventId":
parameter = _db.AddParameter(cmd, paramName, DbType.AnsiStringFixedLength, value);
break;
case "EventTimeUtc":
parameter = _db.AddParameter(cmd, paramName, DbType.DateTime, value);
break;
case "EventTime":
parameter = _db.AddParameter(cmd, paramName, DbType.DateTime, value);
break;
case "EventType":
parameter = _db.AddParameter(cmd, paramName, DbType.String, value);
break;
case "EventSequence":
parameter = _db.AddParameter(cmd, paramName, DbType.Decimal, value);
break;
case "EventOccurrence":
parameter = _db.AddParameter(cmd, paramName, DbType.Decimal, value);
break;
case "EventCode":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "EventDetailCode":
parameter = _db.AddParameter(cmd, paramName, DbType.Int32, value);
break;
case "Message":
parameter = _db.AddParameter(cmd, paramName, DbType.String, value);
break;
case "ApplicationPath":
parameter = _db.AddParameter(cmd, paramName, DbType.String, value);
break;
case "ApplicationVirtualPath":
parameter = _db.AddParameter(cmd, paramName, DbType.String, value);
break;
case "MachineName":
parameter = _db.AddParameter(cmd, paramName, DbType.String, value);
break;
case "RequestUrl":
parameter = _db.AddParameter(cmd, paramName, DbType.String, value);
break;
case "ExceptionType":
parameter = _db.AddParameter(cmd, paramName, DbType.String, value);
break;
case "Details":
parameter = _db.AddParameter(cmd, paramName, DbType.String, value);
break;
default:
throw new ArgumentException("Unknown parameter name (" + paramName + ").");
}
return(parameter);
}
