public OpertionResult Create(PartnerActivity partnerActivity) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "v_act_id", OracleDbType = OracleDbType.Varchar2, Value = partnerActivity.Activity.Id }, new OracleParameter { ParameterName = "v_fromroleid", OracleDbType = OracleDbType.Int32, Value = partnerActivity.FromRole.Id }, new OracleParameter { ParameterName = "v_queryduration", OracleDbType = OracleDbType.Varchar2, Value = partnerActivity.MaxQueryDuration.Id }, new OracleParameter { ParameterName = "v_act_scope", OracleDbType = OracleDbType.Varchar2, Value = partnerActivity.Scope.Id }, new OracleParameter { ParameterName = "v_maxrec", OracleDbType = OracleDbType.Int32, Value = partnerActivity.MaxQueryRows }, new OracleParameter { ParameterName = "v_onlypartchildren", OracleDbType = OracleDbType.Int32, Value = partnerActivity.OnlyPartnerChildren ? 1 : 0 }, new OracleParameter { ParameterName = "v_createdby", OracleDbType = OracleDbType.Varchar2, Value = partnerActivity.CreatedBy.Id }, new OracleParameter { ParameterName = "v_createdbyacc", OracleDbType = OracleDbType.Int32, Value = partnerActivity.CreatedBy.Account } }; #endregion db.ExecuteStoredProc("pk_Settings.fn_CreatePartnerActivity", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); if (result > 0) { return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); } else { return(new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }); } } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }
public OpertionResult Create(UserNotify obj, bool thenPostIt = false) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "v_subject", OracleDbType = OracleDbType.NVarchar2, Value = obj.Subject }, new OracleParameter { ParameterName = "v_content", OracleDbType = OracleDbType.NVarchar2, Value = obj.Content }, new OracleParameter { ParameterName = "v_priority", OracleDbType = OracleDbType.Varchar2, Value = obj.Priority.Id }, new OracleParameter { ParameterName = "v_createdbyid", OracleDbType = OracleDbType.Varchar2, Value = obj.CreatedBy.Id }, new OracleParameter { ParameterName = "v_expire_time", OracleDbType = OracleDbType.Date, Value = obj.ExpireOn }, new OracleParameter { ParameterName = "v_post_it", OracleDbType = OracleDbType.Int32, Value = thenPostIt ? 1 : 0 } }; #endregion db.ExecuteStoredProc("pk_infra.fn_create_usersinstruct", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); if (result > 0) { foreach (var item in obj.NotifyToList) { item.UserNotifyId = result; CreateUserNotifyTo(item); } return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); } else { return(new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }); } } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }
public OpertionResult Create(ActivityMessage msg) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "v_act_id", OracleDbType = OracleDbType.Varchar2, Value = msg.Activity.Id }, new OracleParameter { ParameterName = "v_msg_id", OracleDbType = OracleDbType.Int32, Value = msg.Message.Id }, new OracleParameter { ParameterName = "v_sending_time", OracleDbType = OracleDbType.Varchar2, Value = msg.SendingTime.Id }, new OracleParameter { ParameterName = "v_createdby", OracleDbType = OracleDbType.Varchar2, Value = msg.CreatedBy.Id }, new OracleParameter { ParameterName = "v_createdbyacc", OracleDbType = OracleDbType.Int32, Value = msg.CreatedBy.Account }, new OracleParameter { ParameterName = "v_msg_order", OracleDbType = OracleDbType.Int32, Value = msg.MessageOrder } }; #endregion db.ExecuteStoredProc("pk_settings.fn_create_activity_message", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); if (result > 0) { return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); } else { return(new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }); } } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }
public bool ChangePwd(int PartnerAcc, string PartnerId, string newPwd, bool notify = true) { //var pass = Utility.GenerateNewCode(4); byte[] salt = Pbkdf2Hasher.GenerateRandomSalt(); string hash = Pbkdf2Hasher.ComputeHash(newPwd, salt); try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "v_partner_acc", OracleDbType = OracleDbType.Int32, Value = PartnerAcc }, new OracleParameter { ParameterName = "v_pwd", OracleDbType = OracleDbType.Varchar2, Value = hash }, new OracleParameter { ParameterName = "v_extra", OracleDbType = OracleDbType.Varchar2, Value = Convert.ToBase64String(salt) } }; #endregion db.ExecuteStoredProc("pk_infra.fn_ChangePassword", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); if (result > 0) { if (notify) { var msg = "تم تغيير الرقم السري الخاصب بك الى " + newPwd; new OutSMSRepo(db).Create(new SMSOut { Receiver = PartnerId, Message = msg }); } return(true); } else { return(false); } } catch (Exception ex) { return(false); } }
public OpertionResult Create(MessageTemplate template) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "v_msg_name", OracleDbType = OracleDbType.NVarchar2, Value = template.Title }, new OracleParameter { ParameterName = "v_msg_text", OracleDbType = OracleDbType.NVarchar2, Value = template.Message }, new OracleParameter { ParameterName = "v_createdby", OracleDbType = OracleDbType.Varchar2, Value = template.CreatedBy.Id }, new OracleParameter { ParameterName = "v_createdbyacc", OracleDbType = OracleDbType.Int32, Value = template.CreatedBy.Account }, new OracleParameter { ParameterName = "v_towho", OracleDbType = OracleDbType.Int32, Value = template.ToWho } }; #endregion db.ExecuteStoredProc("pk_settings.fn_create_message_template", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); if (result > 0) { return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); } else { return(new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }); } } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }
public OpertionResult Create(PaymentValues pValue) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "v_pvalue", OracleDbType = OracleDbType.Double, Value = pValue.PayValue }, new OracleParameter { ParameterName = "v_createdby", OracleDbType = OracleDbType.Varchar2, Value = pValue.CreatedBy.Id }, new OracleParameter { ParameterName = "v_created_acc", OracleDbType = OracleDbType.Int32, Value = pValue.CreatedBy.Account }, new OracleParameter { ParameterName = "v_profile_id", OracleDbType = OracleDbType.Int32, Value = pValue.ProfileId } }; #endregion _db.ExecuteStoredProc("pk_infra.fn_create_pay_values", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); if (result > 0) { return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); } else { return(new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }); } } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }
public OpertionResult Create(DataAudit data) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "v_partner_id", OracleDbType = OracleDbType.Varchar2, Value = data.PartnerId }, new OracleParameter { ParameterName = "v_partner_acc", OracleDbType = OracleDbType.Int32, Value = data.PartnerAccount }, new OracleParameter { ParameterName = "v_act_id", OracleDbType = OracleDbType.Varchar2, Value = data.Activity.Id }, new OracleParameter { ParameterName = "v_action_id", OracleDbType = OracleDbType.Varchar2, Value = data.Action.Id }, new OracleParameter { ParameterName = "v_note", OracleDbType = OracleDbType.NVarchar2, Value = data.Note }, new OracleParameter { ParameterName = "v_old_value", OracleDbType = OracleDbType.NVarchar2, Value = data.OldValue }, new OracleParameter { ParameterName = "v_new_value", OracleDbType = OracleDbType.NVarchar2, Value = data.NewValue }, new OracleParameter { ParameterName = "v_system_note", OracleDbType = OracleDbType.NVarchar2, Value = data.SystemNote }, new OracleParameter { ParameterName = "v_error", OracleDbType = OracleDbType.Varchar2, Value = data.Error }, new OracleParameter { ParameterName = "v_success", OracleDbType = OracleDbType.Int32, Value = data.Success ? 1 : 0 } }; #endregion var result = db.ExecuteStoredProc("pk_utility.sp_create_audit", parameters); return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); //if (result > 0) //{ // return new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }; //} //else //{ // return new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }; //} } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }
public OpertionResult Create(PartnerStatusLog log) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "v_createdby", OracleDbType = OracleDbType.Varchar2, Value = log.CreatedBy.Id }, new OracleParameter { ParameterName = "v_createdbyacc", OracleDbType = OracleDbType.Int32, Value = log.CreatedBy.Account }, new OracleParameter { ParameterName = "v_partner_id", OracleDbType = OracleDbType.Varchar2, Value = log.Partner.Id }, new OracleParameter { ParameterName = "v_partner_acc", OracleDbType = OracleDbType.Int32, Value = log.Partner.Account }, new OracleParameter { ParameterName = "v_old_status", OracleDbType = OracleDbType.Int32, Value = log.OldStatus.Id }, new OracleParameter { ParameterName = "v_new_status", OracleDbType = OracleDbType.Int32, Value = log.NewStatus.Id }, new OracleParameter { ParameterName = "v_note", OracleDbType = OracleDbType.NVarchar2, Value = log.Note }, new OracleParameter { ParameterName = "v_newstatus_expireon", OracleDbType = OracleDbType.Date, Value = log.NewStatusExpireOn } }; #endregion db.ExecuteStoredProc("pk_infra.fn_create_partnerstatus_log", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); if (result > 0) { return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); } else { return(new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }); } } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }
public OpertionResult Create(Adjustment adjust) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "v_createdby", OracleDbType = OracleDbType.Varchar2, Value = adjust.CreatedBy.Id }, new OracleParameter { ParameterName = "v_moneytranferid", OracleDbType = OracleDbType.Int32, Value = adjust.MoneyTransferId }, new OracleParameter { ParameterName = "v_amount", OracleDbType = OracleDbType.Decimal, Value = adjust.Amount }, new OracleParameter { ParameterName = "v_access_channel", OracleDbType = OracleDbType.Varchar2, Value = adjust.AccessChannel.Id }, new OracleParameter { ParameterName = "v_note", OracleDbType = OracleDbType.NVarchar2, Value = adjust.Note }, new OracleParameter { ParameterName = "v_createdbyacc", OracleDbType = OracleDbType.Varchar2, Value = adjust.CreatedBy.Account } }; #endregion db.ExecuteStoredProc("pk_financial.fn_create_adjustment", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); if (result > 0) { return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); } else { return(new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }); } } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }
public OpertionResult Create(ApiIPBlacklist obj) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "v_ip_address", OracleDbType = OracleDbType.Varchar2, Value = obj.IPAddress } }; #endregion _db.ExecuteStoredProc("pk_infra.fn_create_api_ip_blacklist", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); if (result > 0) { return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); } else { return(new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }); } } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }
public OpertionResult Create(ApiLogFile obj) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "v_log_data", OracleDbType = OracleDbType.NVarchar2, Value = obj.Data }, new OracleParameter { ParameterName = "v_log_user", OracleDbType = OracleDbType.Varchar2, Value = obj.User }, new OracleParameter { ParameterName = "v_log_ip", OracleDbType = OracleDbType.Varchar2, Value = obj.Ip }, new OracleParameter { ParameterName = "v_log_level", OracleDbType = OracleDbType.Int32, Value = obj.Level }, new OracleParameter { ParameterName = "v_log_action", OracleDbType = OracleDbType.Varchar2, Value = obj.Action } }; #endregion _db.ExecuteStoredProc("pk_infra.fn_create_api_log", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); if (result > 0) { return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); } else { return(new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }); } } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }
public OpertionResult Create(SMSIn sms) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "v_reciever", OracleDbType = OracleDbType.Varchar2, Value = sms.Receiver }, new OracleParameter { ParameterName = "v_sender", OracleDbType = OracleDbType.Varchar2, Value = sms.Sender }, new OracleParameter { ParameterName = "v_message", OracleDbType = OracleDbType.NVarchar2, Value = sms.Message }, new OracleParameter { ParameterName = "v_ref_no", OracleDbType = OracleDbType.Int32, Value = sms.RefNo }, new OracleParameter { ParameterName = "v_lang", OracleDbType = OracleDbType.Varchar2, Value = sms.Lang } }; #endregion db.ExecuteStoredProc("pk_infra.fn_create_in_sms", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); if (result > 0) { return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); } else { return(new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }); } } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }
public OpertionResult Create(SMSOne created) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "v_createdby", OracleDbType = OracleDbType.Varchar2, Value = created.CreatedBy.Id }, new OracleParameter { ParameterName = "v_createdbyacc", OracleDbType = OracleDbType.Int32, Value = created.CreatedBy.Account }, new OracleParameter { ParameterName = "v_receiver", OracleDbType = OracleDbType.Varchar2, Value = created.Receiver }, new OracleParameter { ParameterName = "v_msg", OracleDbType = OracleDbType.NVarchar2, Value = created.Message }, new OracleParameter { ParameterName = "v_note", OracleDbType = OracleDbType.NVarchar2, Value = created.Note } }; #endregion db.ExecuteStoredProc("pk_infra.fn_create_smsone", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); if (result > 0) { return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); } else { return(new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }); } } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }
private OpertionResult GeneratePFR(int account, DateTime startDate, DateTime endDate) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "account", OracleDbType = OracleDbType.Int32, Value = account }, new OracleParameter { ParameterName = "startdate", OracleDbType = OracleDbType.Date, Value = startDate }, new OracleParameter { ParameterName = "enddate", OracleDbType = OracleDbType.Date, Value = endDate } }; #endregion db.ExecuteStoredProc("pk_financial.fn_generate_pfr", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); if (result > 0) { return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); } else { return(new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }); } } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }
public OpertionResult Read(int id) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "v_his_id", OracleDbType = OracleDbType.Int32, Value = id } }; #endregion db.ExecuteStoredProc("pk_infra.fn_read_userinstructhis", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); if (result > 0) { return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); } else { return(new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }); } } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }
public OpertionResult Create(PartnerRequest req) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "v_req_id", OracleDbType = OracleDbType.Int32, Value = req.RequestId }, new OracleParameter { ParameterName = "v_req_content", OracleDbType = OracleDbType.Varchar2, Value = req.Content }, new OracleParameter { ParameterName = "v_replay_time", OracleDbType = OracleDbType.Date, Value = req.ReplayTime }, new OracleParameter { ParameterName = "v_replay_desc", OracleDbType = OracleDbType.Varchar2, Value = req.ReplayDesc }, new OracleParameter { ParameterName = "v_replay_shortcode", OracleDbType = OracleDbType.Varchar2, Value = req.Shortcode }, new OracleParameter { ParameterName = "v_status", OracleDbType = OracleDbType.Int32, Value = req.Status }, new OracleParameter { ParameterName = "v_queue_no", OracleDbType = OracleDbType.Int32, Value = req.QueueNo }, new OracleParameter { ParameterName = "v_error", OracleDbType = OracleDbType.Varchar2, Value = req.Error }, new OracleParameter { ParameterName = "v_accesschannel", OracleDbType = OracleDbType.Varchar2, Value = req.AccessChannel }, }; #endregion db.ExecuteStoredProc("pk_infra.fn_create_partner_request", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); if (result > 0) { return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); } else { return(new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }); } } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }
public OpertionResult Create(RechargeCollection rechargeCollection) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "v_subs_no", OracleDbType = OracleDbType.Varchar2, Value = rechargeCollection.SubscriberNo }, new OracleParameter { ParameterName = "v_amount", OracleDbType = OracleDbType.Decimal, Value = rechargeCollection.Amount }, new OracleParameter { ParameterName = "v_pos_id", OracleDbType = OracleDbType.Varchar2, Value = rechargeCollection.PointOfSale.Id }, new OracleParameter { ParameterName = "v_access_channel", OracleDbType = OracleDbType.Varchar2, Value = rechargeCollection.AccessChannel.Id }, new OracleParameter { ParameterName = "v_queue_no", OracleDbType = OracleDbType.Int32, Value = rechargeCollection.QueueNo }, new OracleParameter { ParameterName = "v_ref_no", OracleDbType = OracleDbType.Int32, Value = rechargeCollection.RefNo }, new OracleParameter { ParameterName = "v_ref_message", OracleDbType = OracleDbType.Varchar2, Value = rechargeCollection.RefMessage }, new OracleParameter { ParameterName = "v_ref_time", OracleDbType = OracleDbType.Date, Value = rechargeCollection.RefTime }, new OracleParameter { ParameterName = "v_ref_trans_no", OracleDbType = OracleDbType.Varchar2, Value = rechargeCollection.RefTransNo }, new OracleParameter { ParameterName = "v_debug_info", OracleDbType = OracleDbType.Varchar2, Value = rechargeCollection.DebugInfo }, new OracleParameter { ParameterName = "v_status", OracleDbType = OracleDbType.Int32, Value = rechargeCollection.Status.Id }, new OracleParameter { ParameterName = "v_api_trans", OracleDbType = OracleDbType.Int64, Value = rechargeCollection.ApiTransaction } }; #endregion db.ExecuteStoredProc("pk_financial.fn_create_collection", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); if (result > 0) { return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); } else { return(new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }); } } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }
public OpertionResult Create(AppBackgroundService obj) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "v_createdby", OracleDbType = OracleDbType.Varchar2, Value = obj.CreatedBy.Id }, new OracleParameter { ParameterName = "v_createdbyacc", OracleDbType = OracleDbType.Int32, Value = obj.CreatedBy.Account }, new OracleParameter { ParameterName = "v_bg_source", OracleDbType = OracleDbType.Varchar2, Value = obj.Source.Id }, new OracleParameter { ParameterName = "v_partner_id", OracleDbType = OracleDbType.Varchar2, Value = obj.Partner.Id }, new OracleParameter { ParameterName = "v_partner_acc", OracleDbType = OracleDbType.Int32, Value = obj.Partner.Account }, new OracleParameter { ParameterName = "v_start_date", OracleDbType = OracleDbType.Date, Value = obj.StartDate }, new OracleParameter { ParameterName = "v_end_date", OracleDbType = OracleDbType.Date, Value = obj.EndDate }, new OracleParameter { ParameterName = "v_note", OracleDbType = OracleDbType.NVarchar2, Value = obj.Note }, new OracleParameter { ParameterName = "v_active_time", OracleDbType = OracleDbType.Date, Value = obj.ActiveTime }, new OracleParameter { ParameterName = "v_service_name", OracleDbType = OracleDbType.NVarchar2, Value = obj.Name }, new OracleParameter { ParameterName = "v_action_partner_id", OracleDbType = OracleDbType.Varchar2, Value = obj.ActionPartner.Id } }; #endregion db.ExecuteStoredProc("pk_infra.fn_create_bgservice", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); if (result > 0) { return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); } else { return(new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }); } } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }
public OpertionResult Create(MoneyTransfer transfer) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "v_part_id", OracleDbType = OracleDbType.Varchar2, Value = transfer.Partner.Id }, new OracleParameter { ParameterName = "v_pay_type", OracleDbType = OracleDbType.Varchar2, Value = transfer.PayType.Id }, new OracleParameter { ParameterName = "v_pay_no", OracleDbType = OracleDbType.NVarchar2, Value = transfer.PayNo }, new OracleParameter { ParameterName = "v_pay_date", OracleDbType = OracleDbType.Date, Value = transfer.PayDate }, new OracleParameter { ParameterName = "v_bank_name", OracleDbType = OracleDbType.NVarchar2, Value = transfer.PayBank }, new OracleParameter { ParameterName = "v_createdby", OracleDbType = OracleDbType.Varchar2, Value = transfer.CreatedBy.Id }, new OracleParameter { ParameterName = "v_access_channel", OracleDbType = OracleDbType.Varchar2, Value = transfer.AccessChannel.Id }, new OracleParameter { ParameterName = "v_amount", OracleDbType = OracleDbType.Decimal, Value = transfer.Amount }, new OracleParameter { ParameterName = "v_bill_no", OracleDbType = OracleDbType.Varchar2, Value = transfer.BillNo }, new OracleParameter { ParameterName = "v_request_no", OracleDbType = OracleDbType.Varchar2, Value = transfer.RequestNo }, new OracleParameter { ParameterName = "v_request_amt", OracleDbType = OracleDbType.Decimal, Value = transfer.RequestAmount }, new OracleParameter { ParameterName = "v_note", OracleDbType = OracleDbType.NVarchar2, Value = transfer.Note }, new OracleParameter { ParameterName = "v_api_trans", OracleDbType = OracleDbType.Int64, Value = transfer.ApiTransaction } }; #endregion db.ExecuteStoredProc("pk_financial.fn_MoneyTransfer", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); if (result > 0) { return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); } else { return(new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }); } } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }
public OpertionResult Create(ChangeSecretHistory created) { try { #region Parameters var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "retVal", OracleDbType = OracleDbType.Int32, Direction = ParameterDirection.ReturnValue }, new OracleParameter { ParameterName = "v_createdby", OracleDbType = OracleDbType.Varchar2, Value = created.CreatedBy.Id }, new OracleParameter { ParameterName = "v_createdbyacc", OracleDbType = OracleDbType.Int32, Value = created.CreatedBy.Account }, new OracleParameter { ParameterName = "v_access_channel", OracleDbType = OracleDbType.Varchar2, Value = created.AccessChannel.Id }, new OracleParameter { ParameterName = "v_old_sec_salt", OracleDbType = OracleDbType.Varchar2, Value = created.OldSalt }, new OracleParameter { ParameterName = "v_old_hash", OracleDbType = OracleDbType.Varchar2, Value = created.OldHash }, new OracleParameter { ParameterName = "v_new_salt", OracleDbType = OracleDbType.Varchar2, Value = created.NewSalt }, new OracleParameter { ParameterName = "v_new_hash", OracleDbType = OracleDbType.Varchar2, Value = created.NewHash }, new OracleParameter { ParameterName = "v_chg_type", OracleDbType = OracleDbType.Varchar2, Value = created.ChangeType.Id }, new OracleParameter { ParameterName = "v_notify_by", OracleDbType = OracleDbType.Varchar2, Value = created.NotifyBy.Id }, new OracleParameter { ParameterName = "v_partner_id", OracleDbType = OracleDbType.Varchar2, Value = created.PartAppUser.Id }, new OracleParameter { ParameterName = "v_partner_acc", OracleDbType = OracleDbType.Int32, Value = created.PartAppUser.Account } }; #endregion _db.ExecuteStoredProc("pk_infra.fn_Create_chgSec_his", parameters); var result = int.Parse(parameters.Find(x => x.ParameterName == "retVal").Value.ToString()); if (result > 0) { return(new OpertionResult { AffectedCount = result, Success = true, Error = string.Empty }); } else { return(new OpertionResult { AffectedCount = result, Success = false, Error = string.Empty }); } } catch (Exception ex) { return(new OpertionResult { AffectedCount = -1, Success = false, Error = ex.Message }); } }