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