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();
}
}
