public static bool DeleteMessage(List <ATTMessage> lst) { GetConnection GetConn = new GetConnection(); OracleConnection DBConn = GetConn.GetDbConn(Module.OAS); OracleTransaction Tran = DBConn.BeginTransaction(); try { if (lst.Count > 0) { DLLMessageReceiver.DeleteMessageReceiver(lst, Tran); } Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); throw (ex); } finally { GetConn.CloseDbConn(); } }
public static bool SaveMessage(ATTMessage objMessage) { GetConnection GetConn = new GetConnection(); OracleConnection DBConn = GetConn.GetDbConn(Module.OAS); OracleTransaction Tran = DBConn.BeginTransaction(); string saveSQL = "SP_ADD_MESSAGE"; int countReceiver = objMessage.LstMessageReceiver.Count; int countAttachment = objMessage.LstMsgAttachment.Count; int countCcReceiver = objMessage.LstMessageCcReceiver.Count; OracleParameter[] paramArray = new OracleParameter[17]; paramArray[0] = Utilities.GetOraParam(":P_ORG_IDD", objMessage.OrgID, OracleDbType.Int64, ParameterDirection.Input); paramArray[1] = Utilities.GetOraParam(":P_MSG_ID", objMessage.MessageID, OracleDbType.Int64, ParameterDirection.InputOutput); paramArray[2] = Utilities.GetOraParam(":P_MSG_TYPE_ID", objMessage.MessageTypeID, OracleDbType.Int64, ParameterDirection.Input); paramArray[3] = Utilities.GetOraParam(":P_SENDER_ID", objMessage.SenderID, OracleDbType.Int64, ParameterDirection.Input); paramArray[4] = Utilities.GetOraParam(":P_SUBJECT", objMessage.Subject, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[5] = Utilities.GetOraParam(":P_BODY", objMessage.Body, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[6] = Utilities.GetOraParam(":P_PARENT_MSG_ID", objMessage.ParentMsgID, OracleDbType.Int64, ParameterDirection.Input); paramArray[7] = Utilities.GetOraParam(":P_LETTER_TYPE", objMessage.LetterType, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[8] = Utilities.GetOraParam(":P_TO_ORG_ID", objMessage.ToOrgID, OracleDbType.Int64, ParameterDirection.Input); paramArray[9] = Utilities.GetOraParam(":P_TO_UNIT_ID", objMessage.ToUnitID, OracleDbType.Int64, ParameterDirection.Input); paramArray[10] = Utilities.GetOraParam(":P_TO_P_ID", objMessage.ToPID, OracleDbType.Int64, ParameterDirection.Input); paramArray[11] = Utilities.GetOraParam(":P_FROM_ORG_ID", objMessage.FromOrgID, OracleDbType.Int64, ParameterDirection.Input); paramArray[12] = Utilities.GetOraParam(":P_FROM_UNIT_ID", objMessage.FromUnitID, OracleDbType.Int64, ParameterDirection.Input); paramArray[13] = Utilities.GetOraParam(":P_FROM_P_ID", objMessage.FromPID, OracleDbType.Int64, ParameterDirection.Input); paramArray[14] = Utilities.GetOraParam(":P_APPROVE", objMessage.Approve, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[15] = Utilities.GetOraParam(":P_ENTRY_BY", objMessage.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[16] = Utilities.GetOraParam(":ENTRY_ON", objMessage.EntryOn, OracleDbType.Date, ParameterDirection.Input); try { SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, saveSQL, paramArray); objMessage.MessageID = int.Parse(paramArray[1].Value.ToString()); if (countReceiver > 0) { DLLMessageReceiver.SaveMessageReceiver(objMessage, Tran, "R"); } if (countAttachment > 0) { DLLMessageAttachment.SaveMessageAttachment(objMessage, Tran); } if (countCcReceiver > 0) { DLLMessageReceiver.SaveMessageReceiver(objMessage, Tran, "Cc"); } Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); throw (ex); } finally { GetConn.CloseDbConn(); } }