/// <summary> /// Insert or update Transaction for send SMS /// </summary> /// <param name="obj"></param> /// <returns></returns> public bool TRANSACTION_InsertUpdate(Librarys.CRM.TRANSACTION obj) { Helpers.Connection.sConnectionStringDatabase = ConfigurationManager.ConnectionStrings["sConnectionString_Crm"].ConnectionString; return(FundManagementLib.FundManagementLib.TransactionInsertUpdate(obj)); }
private void Balance_Simpay_Insert_Send(LOGSEND log, decimal balance) { //thoi gian he thong string strNow = string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now); string strNowTitle = string.Format("{0:yyyy-MM-dd}", DateTime.Now); //lay title Email la ruleName Helpers.Connection.sConnectionStringDatabase = ConfigurationManager.ConnectionStrings["sConnectionString_SystemWarning"].ConnectionString; string titleEmail = DataOut.SW_RULES_SelectByID(log.RULE_AUTOID).Tables[0].Rows[0][RULE.COLUMN_RULE_NAME].ToString().Trim(); titleEmail += " " + strNowTitle; //lay noi dung gui la gia tri cua cac conditions string strContentSend = null; DataSet dsContent = new DataSet(); dsContent = DataOut.SW_RULEDETAIL_BALANCESSIMPAY_All(log.RULE_AUTOID); for (int i = 0; i < dsContent.Tables[0].Rows.Count; i++) { //chi lay cac conditions da Active if (Convert.ToBoolean(dsContent.Tables[0].Rows[i][RULEDETAIL.COLUMN_RULEDETAIL_ISACTIVE].ToString().Trim()) == true) { //truong hop condition "so du tai khoan" if (Convert.ToInt64(dsContent.Tables[0].Rows[i][RULEDETAIL.COLUMN_CONDITION_AUTOID].ToString().Trim()) == 3) { strContentSend += (dsContent.Tables[0].Rows[i]["CONDITION_NAME"].ToString().Trim()) + ": " + balance.ToString("#,##0 VNĐ") + " " + (dsContent.Tables[0].Rows[i]["KEY_NOTE2"].ToString().Trim()) + " " + Convert.ToDecimal(dsContent.Tables[0].Rows[i]["KEYVALUE"].ToString().Trim()).ToString("#,##0 VNĐ") + "; "; } //truong hop condition "nha cung cap" else if (Convert.ToInt64(dsContent.Tables[0].Rows[i][RULEDETAIL.COLUMN_CONDITION_AUTOID].ToString().Trim()) == 2) { strContentSend += (dsContent.Tables[0].Rows[i]["CONDITION_NAME"].ToString().Trim()) + ": " + (dsContent.Tables[0].Rows[i]["KEYVALUE"].ToString().Trim()) + "; "; } //truong hop condition "thoi diem" else if (Convert.ToInt64(dsContent.Tables[0].Rows[i][RULEDETAIL.COLUMN_CONDITION_AUTOID].ToString().Trim()) == 4) { //truong hop la ngay co dinh if (Convert.ToInt64(dsContent.Tables[0].Rows[i][RULEDETAIL.COLUMN_RULEDETAIL_TYPE].ToString().Trim()) == 3) { strContentSend += (dsContent.Tables[0].Rows[i]["CONDITION_NAME"].ToString().Trim()) + ": " + (dsContent.Tables[0].Rows[i]["KEYVALUE"].ToString().Trim()) + "; "; } //truong hop chon thu else { strContentSend += (dsContent.Tables[0].Rows[i]["CONDITION_NAME"].ToString().Trim()) + ": " + (dsContent.Tables[0].Rows[i]["CONDITIONDETAIL_VALUE"].ToString().Trim()) + "; "; } } } } //send message Helpers.Connection.sConnectionStringDatabase = ConfigurationManager.ConnectionStrings["sConnectionString_Crm"].ConnectionString; //SMS if (log.ACTION_AUTOID == 1) { //insert vao DB SMS Librarys.CRM.TRANSACTION trans = new Librarys.CRM.TRANSACTION(); trans.RECEIVEACCOUNT = log.USERSEND_HANDPHONE; trans.FROMACCOUNT = ""; trans.LASTUPDATE = DateTime.Now; trans.CODE = 1; trans.STATUS = 1; trans.VALUE = Protect.RemoveVNString(strContentSend).Trim(); trans.TRANSTYPECODE = 4; trans.RECEIVEID = DateTime.Now.Ticks.ToString(); trans.COMSIMID = 0; DataIn.CRM_TRANSACTION_InsertUpdate(trans); } //EMAIL else if (log.ACTION_AUTOID == 2) { //insert vao DB EMAIL Librarys.CRM.TRANSACTION trans = new Librarys.CRM.TRANSACTION(); trans.RECEIVEACCOUNT = log.USERSEND_EMAIL; trans.FROMACCOUNT = "*****@*****.**"; trans.LASTUPDATE = DateTime.Now; trans.CODE = 1; trans.STATUS = 1; trans.VALUE = string.Format("{0}##{1}", titleEmail, strNow + "; " + strContentSend); trans.TRANSTYPECODE = 10; trans.RECEIVEID = "<" + Guid.NewGuid().ToString() + "@simpay.com.vn>"; trans.COMSIMID = 0; DataIn.CRM_TRANSACTION_InsertUpdate(trans); } }