public bool Delete(int id) { var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "Row_Id", OracleDbType = OracleDbType.Int32, Value = id } }; return(db.ExecuteSqlCommand("Delete from Partner_Activity Where Row_Id=:Row_Id", parameters) > 0); }
public bool RemoveMessage(int id) { var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "MsgId", OracleDbType = OracleDbType.Int32, Value = id } }; return(db.ExecuteSqlCommand("Delete from SMS_OUT Where Row_Id=:MsgId", parameters) > 0); }
public bool IncreaseWrongPwdAttempts(string partnerId, bool lockAccount) { var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "PartnerId", OracleDbType = OracleDbType.Varchar2, Value = partnerId }, }; string sql = string.Empty; if (lockAccount) { sql = "Update partner set WRONG_PWD_ATTEMPTS = WRONG_PWD_ATTEMPTS + 1, status = 2, statuson=sysdate, locktime = sysdate + 1/24 where partner_id = :PartnerId and status = 1"; } else { sql = "Update partner set WRONG_PWD_ATTEMPTS = WRONG_PWD_ATTEMPTS + 1 where partner_id = :PartnerId and status = 1"; } return(db.ExecuteSqlCommand(sql, parameters) > 0); }
public bool UpdateOrder(string actId, int msgId, int newOrder) { var parameters = new List <OracleParameter> { new OracleParameter { ParameterName = "actId", OracleDbType = OracleDbType.Varchar2, Value = actId }, new OracleParameter { ParameterName = "msgId", OracleDbType = OracleDbType.Int32, Value = msgId } //new OracleParameter{ ParameterName = "MOrder", OracleDbType = OracleDbType.Int32, Value = newOrder } }; var result = db.ExecuteSqlCommand("UPDATE ACTIVITY_MESSAGE SET msg_order=" + newOrder + " WHERE act_id=:actId AND msg_id=:msgId", parameters); return(result > 0); }