public override void Insert(CarrierAcctRow value) { string _sqlStr = "DECLARE " + base.Database.CreateSqlParameterName(CarrierAcctRow.carrier_acct_id_PropName) + " smallint " + "SET " + base.Database.CreateSqlParameterName(CarrierAcctRow.carrier_acct_id_PropName) + " = COALESCE((SELECT MAX(" + CarrierAcctRow.carrier_acct_id_DbName + ") FROM CarrierAcct) + 1, 10000) " + "INSERT INTO [dbo].[CarrierAcct] (" + "[" + CarrierAcctRow.carrier_acct_id_DbName + "], " + "[" + CarrierAcctRow.name_DbName + "], " + "[" + CarrierAcctRow.status_DbName + "], " + "[" + CarrierAcctRow.rating_type_DbName + "], " + "[" + CarrierAcctRow.prefix_out_DbName + "], " + "[" + CarrierAcctRow.max_call_length_DbName + "], " + "[" + CarrierAcctRow.strip_1plus_DbName + "], " + "[" + CarrierAcctRow.intl_dial_code_DbName + "], " + "[" + CarrierAcctRow.partner_id_DbName + "], " + "[" + CarrierAcctRow.calling_plan_id_DbName + "] " + ") VALUES (" + //"@Carrier_id, " + Database.CreateSqlParameterName(CarrierAcctRow.carrier_acct_id_PropName) + ", " + Database.CreateSqlParameterName(CarrierAcctRow.name_PropName) + ", " + Database.CreateSqlParameterName(CarrierAcctRow.status_PropName) + ", " + Database.CreateSqlParameterName(CarrierAcctRow.rating_type_PropName) + ", " + Database.CreateSqlParameterName(CarrierAcctRow.prefix_out_PropName) + ", " + Database.CreateSqlParameterName(CarrierAcctRow.max_call_length_PropName) + ", " + Database.CreateSqlParameterName(CarrierAcctRow.strip_1plus_PropName) + ", " + Database.CreateSqlParameterName(CarrierAcctRow.intl_dial_code_PropName) + ", " + Database.CreateSqlParameterName(CarrierAcctRow.partner_id_PropName) + ", " + Database.CreateSqlParameterName(CarrierAcctRow.calling_plan_id_PropName) + ") " + "SELECT " + Database.CreateSqlParameterName(CarrierAcctRow.carrier_acct_id_PropName); IDbCommand _cmd = Database.CreateCommand(_sqlStr); //AddParameter(cmd, "Carrier_id", DbType.Int32, value.Carrier_id); AddParameter(_cmd, CarrierAcctRow.name_PropName, value.Name); AddParameter(_cmd, CarrierAcctRow.status_PropName, value.Status); AddParameter(_cmd, CarrierAcctRow.rating_type_PropName, value.Rating_type); AddParameter(_cmd, CarrierAcctRow.prefix_out_PropName, value.Prefix_out); AddParameter(_cmd, CarrierAcctRow.max_call_length_PropName, value.Max_call_length); AddParameter(_cmd, CarrierAcctRow.strip_1plus_PropName, value.Strip_1plus); AddParameter(_cmd, CarrierAcctRow.intl_dial_code_PropName, value.Intl_dial_code); AddParameter(_cmd, CarrierAcctRow.partner_id_PropName, value.Partner_id); AddParameter(_cmd, CarrierAcctRow.calling_plan_id_PropName, value.Calling_plan_id); object _res = _cmd.ExecuteScalar(); value.Carrier_acct_id = (short)_res; }
public bool IsDeactivated(CarrierAcctRow pOriginal) { return(this.AccountStatus != pOriginal.AccountStatus && this.AccountStatus != Rbr.Core.Config.Status.Active); }
public bool IsNameChanged(CarrierAcctRow pOriginal) { return(this.Name != pOriginal.Name); }