public static List <ATTMessage> GetMessageByIDs(int?orgID, int?msgID) { List <ATTMessage> lst = new List <ATTMessage>(); try { DataTable tbl = DLLMessage.GetMessageByIDs(orgID, msgID); foreach (DataRow row in tbl.Rows) { ATTMessage msg = new ATTMessage(); msg.OrgID = int.Parse(row["org_id"].ToString()); msg.MessageID = int.Parse(row["msg_id"].ToString()); msg.Body = row["body"].ToString(); //fill remaining properties as required lst.Add(msg); } tbl.Dispose(); return(lst); } catch (Exception ex) { throw ex; } }
public static bool SaveMessageAttachment(ATTMessage objMessage, OracleTransaction Tran) { try { string saveSQL = "SP_ADD_MESSAGE_ATTACHMENT"; foreach (ATTMessageAttachment objMsgAttachment in objMessage.LstMsgAttachment) { OracleParameter[] paramArray = new OracleParameter[5]; objMsgAttachment.OrgID = objMessage.OrgID; objMsgAttachment.MessageID = objMessage.MessageID; paramArray[0] = Utilities.GetOraParam(":P_ORG_ID", objMsgAttachment.OrgID, OracleDbType.Int64, ParameterDirection.Input); paramArray[1] = Utilities.GetOraParam(":P_MSG_ID", objMsgAttachment.MessageID, OracleDbType.Int64, ParameterDirection.Input); paramArray[2] = Utilities.GetOraParam(":p_ATTACHMENT_ID", null, OracleDbType.Int64, ParameterDirection.InputOutput); paramArray[3] = Utilities.GetOraParam(":p_FILE_BYTES", objMsgAttachment.ContentFile, OracleDbType.Blob, ParameterDirection.Input); paramArray[4] = Utilities.GetOraParam(":p_FILE_NAME", objMsgAttachment.FileName, OracleDbType.Varchar2, ParameterDirection.Input); SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, saveSQL, paramArray); } return(true); } catch (Exception ex) { throw (ex); } }
protected void Page_Load(object sender, EventArgs e) { Response.ExpiresAbsolute = DateTime.Now.AddDays(-1d); Response.Expires = -1500; Response.CacheControl = "no-cache"; if (Session["Login_User_Detail"] == null) { Response.Redirect("~/MODULES/Login.aspx", true); } user = ((ATTUserLogin)Session["Login_User_Detail"]); orgID = user.OrgID; entryBy = user.UserName; userID = int.Parse(user.PID.ToString()); if (Session["objRqdMsg"] != null) { objRqdMsg = (ATTMessage)Session["objRqdMsg"]; } else { Response.Redirect("MessageInbox.aspx"); } if (!IsPostBack) { Session["LstRplyMsgAttachment"] = null; LoadMsgData(); } }
public void LoadOutBoxDetails() { try { GridView gv = (GridView)Session["rqdOutBoxGrdSender"]; GridViewRow row = gv.SelectedRow; int orgID = int.Parse(row.Cells[1].Text); int msgID = int.Parse(row.Cells[2].Text); List <ATTMessage> lstAllMsg = new List <ATTMessage>(); lstAllMsg = (List <ATTMessage>)Session["MessageOutLst"]; ATTMessage objRqdMsg = lstAllMsg.Find(delegate(ATTMessage obj) { return(obj.OrgID == orgID && obj.MessageID == msgID); } ); if (objRqdMsg != null) { string sentToLst; lblFromData.Text = objRqdMsg.Sender; lblSentData.Text = objRqdMsg.EntryOn.ToString(); lblSubjectData.Text = objRqdMsg.Subject; HtmlEditor.Text = objRqdMsg.Body; sentToLst = GetSentToList(objRqdMsg); lblToData.Text = sentToLst; if (sentToLst.Length > 168) { ScriptManager.RegisterStartupScript(this, this.GetType(), "showTr", "javascript:setDivDimension();", true); } //ScriptManager.RegisterStartupScript(this, this.GetType(), "showTr", "javascript:showTr('trForOutBox');", true); if (objRqdMsg.LstMsgAttachment.Count > 0) { dlUpdAttachment.DataSource = GetOutboxAttachmentList(objRqdMsg); dlUpdAttachment.DataBind(); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "hideTr", "javascript:hideTr('trForAttach');", true); } } Session["objRqdMsg"] = objRqdMsg; Session["rqdOutBoxGrdSender"] = null; } catch (Exception ex) { throw (ex); } }
public static bool SaveMessageReceiver(ATTMessage objMessage, OracleTransaction Tran, string type) { try { string saveSQL = "SP_ADD_MESSAGE_RECEIVER"; List <ATTMessageReceiver> lstMsgReceiver = new List <ATTMessageReceiver>(); if (type == "R") { lstMsgReceiver = objMessage.LstMessageReceiver; } else if (type == "Cc") { lstMsgReceiver = objMessage.LstMessageCcReceiver; } foreach (ATTMessageReceiver objMsgReceiver in lstMsgReceiver) //foreach (ATTMessageReceiver objMsgReceiver in objMessage.LstMessageReceiver) { OracleParameter[] paramArray = new OracleParameter[14]; objMsgReceiver.OrgID = objMessage.OrgID; objMsgReceiver.MessageID = objMessage.MessageID; paramArray[0] = Utilities.GetOraParam(":P_ORG_ID", objMsgReceiver.OrgID, OracleDbType.Int64, ParameterDirection.Input); paramArray[1] = Utilities.GetOraParam(":P_MSG_ID", objMsgReceiver.MessageID, OracleDbType.Int64, ParameterDirection.Input); paramArray[2] = Utilities.GetOraParam(":P_MSG_SEQ", null, OracleDbType.Int64, ParameterDirection.InputOutput); paramArray[3] = Utilities.GetOraParam(":P_IS_GRP_RECEIVER", objMsgReceiver.IsGrpReceiver, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[4] = Utilities.GetOraParam(":P_GRP_ORG_ID", objMsgReceiver.ReceiverOrgID, OracleDbType.Int64, ParameterDirection.Input); paramArray[5] = Utilities.GetOraParam(":P_GRP_ID", objMsgReceiver.GroupID, OracleDbType.Int64, ParameterDirection.Input); paramArray[6] = Utilities.GetOraParam(":P_GRP_RECEIVER_ID", objMsgReceiver.ReceiverID, OracleDbType.Int64, ParameterDirection.Input); paramArray[7] = Utilities.GetOraParam(":P_GRP_FROM_DATE", objMsgReceiver.GrpFromDate, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[8] = Utilities.GetOraParam(":P_OTHER_ORG_ID", objMsgReceiver.OtherOrgID, OracleDbType.Int64, ParameterDirection.Input); paramArray[9] = Utilities.GetOraParam(":P_OTHER_UNIT_ID", objMsgReceiver.OtherUnitID, OracleDbType.Int64, ParameterDirection.Input); paramArray[10] = Utilities.GetOraParam(":P_OTHER_RECEIVER_ID", objMsgReceiver.OtherReceiverID, OracleDbType.Int64, ParameterDirection.Input); paramArray[11] = Utilities.GetOraParam(":P_IS_CC", objMsgReceiver.IsCc, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[12] = Utilities.GetOraParam(":P_ENTRY_BY", objMsgReceiver.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[13] = Utilities.GetOraParam(":ENTRY_ON", objMsgReceiver.EntryOn, OracleDbType.Date, ParameterDirection.Input); SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, saveSQL, paramArray); } return(true); } catch (Exception ex) { throw (ex); } }
protected void Page_Load(object sender, EventArgs e) { Response.ExpiresAbsolute = DateTime.Now.AddDays(-1d); Response.Expires = -1500; Response.CacheControl = "no-cache"; if (Session["Login_User_Detail"] == null) { Response.Redirect("~/MODULES/Login.aspx", true); } user = ((ATTUserLogin)Session["Login_User_Detail"]); orgID = user.OrgID; entryBy = user.UserName; userID = int.Parse(user.PID.ToString()); if (Session["objRqdMsg"] != null) { objRqdMsg = (ATTMessage)Session["objRqdMsg"]; } else { Response.Redirect("MessageInbox.aspx"); } if (!IsPostBack) { Session["LstRplyMsgAttachment"] = null; LoadMsgData(); string dateString = BLLDate.GetDateString(0, 0, "_N"); int len = dateString.Length; TodayDate = dateString.Substring(0, len - 5); Session["LetterDate"] = null; Session["LetterTitle"] = null; Session["LetterBody"] = null; Session["LetterFooter"] = null; } string date = " <p align= right> मिति : " + TodayDate + " </P><br><br>"; LetterDate = date; }
public static bool SaveMessage(ATTMessage objMessage) { try { if (DLLMessage.SaveMessage(objMessage)) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } }
public List <ATTMessageAttachment> GetOutboxAttachmentList(ATTMessage objRqdMsg) { try { List <ATTMessageAttachment> tmpAttachmentLst = new List <ATTMessageAttachment>(); ArrayList arrVal = new ArrayList(); foreach (ATTMessageAttachment objAttachment in objRqdMsg.LstMsgAttachment) { int l = 0; bool flag = false; if (arrVal.Count > 0) { for (int k = 0; k < arrVal.Count; k++) { if (objAttachment.AttachmentID == int.Parse(arrVal[k].ToString())) { flag = true; break; } } } if (!flag) { ATTMessageAttachment obj = new ATTMessageAttachment(); obj.OrgID = objAttachment.OrgID; obj.MessageID = objAttachment.MessageID; obj.AttachmentID = objAttachment.AttachmentID; obj.FileName = objAttachment.FileName; arrVal.Add(objAttachment.AttachmentID.ToString()); tmpAttachmentLst.Add(obj); } } return(tmpAttachmentLst); } catch (Exception ex) { throw(ex); } }
public string GetSentToList(ATTMessage objRqdMsg) { try { string sentToLst = ""; //foreach (ATTMessageReceiver objReceiver in objRqdMsg.LstMessageReceiver) //{ // sentToLst += objReceiver.Receiver + "; "; //} foreach (ATTMessageReceiver objReceiver in objRqdMsg.LstMessageReceiver) { if (objReceiver.Receiver.Trim() != "") { sentToLst += objReceiver.Receiver + "; "; } else if (objReceiver.OtherReceiver.Trim() != "") { sentToLst += objReceiver.OtherReceiver + "; "; } } if (sentToLst.Length > 0) { sentToLst = sentToLst.Substring(0, sentToLst.Length - 2); } btnReply.Visible = false; Session["rqdOutBoxGrdSender"] = null; return(sentToLst); } catch (Exception ex) { throw(ex); } }
public List <ATTMessage> GetCheckedLst() { ArrayList arrMsgToDelete = new ArrayList(); List <ATTMessage> lst = new List <ATTMessage>(); try { CheckBox chkInboxMsg; if (grdMessageInbox.Rows.Count > 0) { foreach (GridViewRow gvr in grdMessageInbox.Rows) { ATTMessage obj = new ATTMessage(); chkInboxMsg = (CheckBox)gvr.FindControl("chkInboxMsg"); if (chkInboxMsg.Checked) { obj.OrgID = orgID; obj.MessageID = int.Parse(gvr.Cells[2].Text); obj.MsgSeq = int.Parse(gvr.Cells[7].Text); obj.MsgGrpType = gvr.Cells[8].Text; lst.Add(obj); } } } return(lst); } catch (Exception ex) { this.lblStatusMessageTitle.Text = "Error Status"; this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); return(lst); } }
protected void LinkButton2_Click(object sender, EventArgs e) { try { string arguments = ((LinkButton)sender).CommandArgument.ToString(); CalculateIDs(arguments); ATTMessage objMsg = (ATTMessage)Session["objRqdMsg"]; List <ATTMessageAttachment> lstMsgAttachment = new List <ATTMessageAttachment>(); lstMsgAttachment = objMsg.LstMsgAttachment; ATTMessageAttachment objRqdMsgAttachment = lstMsgAttachment.Find(delegate(ATTMessageAttachment obj) { return(obj.OrgID == orgID && obj.MessageID == msgID && obj.AttachmentID == attachID); } ); if (objRqdMsgAttachment != null) { byte[] fileByte = objRqdMsgAttachment.ContentFile; Response.Clear(); Response.AddHeader("Content-Disposition", "attachment; filename=" + objRqdMsgAttachment.FileName); Response.ContentType = "application/octet-stream"; Response.BinaryWrite(fileByte); } } catch (Exception ex) { throw(ex); } }
public void LoadMsgDetails() { try { GridView gv = (GridView)Session["rqdGrdSender"]; GridViewRow row = gv.SelectedRow; int orgID = int.Parse(row.Cells[1].Text); int msgID = int.Parse(row.Cells[2].Text); int msgSeq = int.Parse(row.Cells[7].Text); int tippaniOrgID = int.Parse(row.Cells[11].Text); int tippaniID = int.Parse(row.Cells[12].Text); if (tippaniOrgID == 0 && tippaniID == 0) { lnkBtnViewLetter.Visible = false; } else { lnkBtnViewLetter.Visible = true; lnkBtnViewLetter.CommandArgument = tippaniOrgID.ToString() + "/" + tippaniID.ToString(); } if (BLLMessageReceiver.UpdateMessageReceiver(orgID, msgID, msgSeq)) { List <ATTMessage> lstAllMsg = new List <ATTMessage>(); lstAllMsg = (List <ATTMessage>)Session["MessageLst"]; ATTMessage objRqdMsg = lstAllMsg.Find(delegate(ATTMessage obj) { return(obj.OrgID == orgID && obj.MessageID == msgID); } ); if (objRqdMsg != null) { Session["tippani_from_message"] = orgID.ToString() + "/" + msgID.ToString(); lblFromData.Text = objRqdMsg.Sender; lblSentData.Text = objRqdMsg.EntryOn.ToString(); lblSubjectData.Text = objRqdMsg.Subject; HtmlEditor.Text = objRqdMsg.Body; if (objRqdMsg.LetterType == "T") { ddlLetterType.SelectedIndex = 1; LoadTippaniTypes(); } else { ddlLetterType.SelectedIndex = 2; } if (objRqdMsg.Approve == "Y") { chkApprove.Checked = true; } else { chkApprove.Checked = false; } ScriptManager.RegisterStartupScript(this, this.GetType(), "hideTr", "javascript:hideTr('trForOutBox');", true); if (objRqdMsg.LstMsgAttachment.Count > 0) { dlUpdAttachment.DataSource = objRqdMsg.LstMsgAttachment; dlUpdAttachment.DataBind(); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "hideTr", "javascript:hideTr('trForAttach');", true); } btnForward.Visible = true; btnPrint.Visible = true; } Session["objRqdMsg"] = objRqdMsg; Session["rqdGrdSender"] = null; } else { this.lblStatusMessageTitle.Text = "Letter View"; this.lblStatusMessage.Text = "ERROR in displaying message detail !!!"; this.programmaticModalPopup.Show(); } } catch (Exception ex) { throw(ex); } }
protected void btnSend_Click(object sender, EventArgs e) { try { ATTMessage objMessage = new ATTMessage(); objMessage.OrgID = orgID; objMessage.MessageID = null; objMessage.SenderID = userID; objMessage.MessageTypeID = 2; if (this.txtSubject_rqd.Text != "") { objMessage.Subject = txtSubject_rqd.Text.Trim(); } if (ddlLetterType.SelectedIndex > 0) { objMessage.LetterType = ddlLetterType.SelectedValue.ToString(); } if (Session["LstRplyMsgAttachment"] != null) { objMessage.LstMsgAttachment = (List <ATTMessageAttachment>)Session["LstRplyMsgAttachment"]; } if (this.HtmlEditor.Text != "") { objMessage.Body = HtmlEditor.Text; } if (chkApprove.Checked) { objMessage.Approve = "Y"; } else { objMessage.Approve = "N"; } objMessage.Action = "A"; objMessage.EntryBy = entryBy; int? receiverID = objRqdMsg.SenderID; bool flag = false; if (receiverID != null) { List <ATTMessageReceiver> lstReceiver = new List <ATTMessageReceiver>(); if (chkGroup.Checked && chkGroup.Visible == true) { int?groupID = int.Parse(objRqdMsg.LstMessageReceiver[0].GroupID.ToString()); int?receiverOrgID = int.Parse(objRqdMsg.LstMessageReceiver[0].ReceiverOrgID.ToString()); lstReceiver.Add(new ATTMessageReceiver(orgID, null, null, "Y", groupID, receiverOrgID, "", null, "A", entryBy)); flag = true; } if (!flag) { lstReceiver.Add(new ATTMessageReceiver(orgID, null, null, "N", null, null, "", receiverID, "A", entryBy)); } if (lstReceiver.Count > 0) { objMessage.LstMessageReceiver = lstReceiver; } } if (BLLMessage.SaveMessage(objMessage)) { ClearControls(); flag = true; string confirmation = "Reply sent successfully to " + objRqdMsg.Sender + " !!!"; this.lblStatusMessageTitle.Text = "Message"; this.lblStatusMessage.Text = confirmation; this.programmaticModalPopup.Show(); } else { flag = false; this.lblStatusMessageTitle.Text = "Message"; this.lblStatusMessage.Text = "Reply sent failed !!!"; this.programmaticModalPopup.Show(); } } catch (Exception ex) { throw(ex); } }
public static List <ATTMessage> GetMessageList(string type, ATTUserLogin login, string searchValue) { try { List <ATTMessage> lstMsg = new List <ATTMessage>(); tblMsg = DLLMessage.GetMessageListTable(type, login, searchValue); tblMsgReceiver = BLLMessageReceiver.GetMessageReceiverListTable(type, login); tblMsgAttachment = BLLMessageAttachment.GetMessageAttachmentListTable(type, login); foreach (DataRow row in tblMsg.Rows) { ATTMessage objMsg = new ATTMessage( int.Parse(row["ORG_ID"].ToString()), int.Parse(row["MSG_ID"].ToString()), int.Parse(row["SENDER_ID"].ToString()), row["S_FIRST_NAME"].ToString() + (row["S_MID_NAME"].ToString() == "" ? "" : row["S_MID_NAME"].ToString()) + (row["S_SUR_NAME"].ToString() == "" ? "" : row["S_SUR_NAME"].ToString()), row["SUBJECT"].ToString(), row["BODY"].ToString(), "N", DateTime.Parse(row["ENTRY_ON"].ToString()) ); objMsg.MessageTypeID = int.Parse(row["MSG_TYPE_ID"].ToString()); objMsg.TippaniOrgID = row["TIP_ORG_ID"].ToString() == "" ? 0: int.Parse(row["TIP_ORG_ID"].ToString()); objMsg.TippaniID = row["TIPPANI_ID"].ToString() == "" ? 0: int.Parse(row["TIPPANI_ID"].ToString()); objMsg.LetterType = row["LETTER_TYPE"].ToString(); objMsg.Approve = row["APPROVE"].ToString(); //,LETTER_TYPE,APPROVE if (type == "IN") { objMsg.MsgSeq = int.Parse(row["MSG_SEQ"].ToString()); objMsg.MsgGrpType = row["is_grp_receiver"].ToString(); objMsg.LstMessageReceiver = SetMessageReceiver(objMsg, int.Parse(row["ORG_ID"].ToString()), int.Parse(row["MSG_ID"].ToString()), int.Parse(row["MSG_SEQ"].ToString()), type); if (tblMsgAttachment.Rows.Count > 0) { objMsg.LstMsgAttachment = SetMessageAttachment(int.Parse(row["ORG_ID"].ToString()), int.Parse(row["MSG_ID"].ToString()), int.Parse(row["MSG_SEQ"].ToString()), type); } } else { objMsg.LstMessageReceiver = SetMessageReceiver(objMsg, int.Parse(row["ORG_ID"].ToString()), int.Parse(row["MSG_ID"].ToString()), null, type); if (tblMsgAttachment.Rows.Count > 0) { objMsg.LstMsgAttachment = SetMessageAttachment(int.Parse(row["ORG_ID"].ToString()), int.Parse(row["MSG_ID"].ToString()), null, type); } } //if (tblMsgAttachment.Rows.Count > 0) //{ // objMsg.LstMsgAttachment = SetMessageAttachment(int.Parse(row["ORG_ID"].ToString()), int.Parse(row["MSG_ID"].ToString())); //} lstMsg.Add(objMsg); } return(lstMsg); } catch (Exception ex) { throw(ex); } }
public static List <ATTMessageReceiver> SetMessageReceiver(ATTMessage objMsg, int orgID, int messageID, int?msgSeq, string type) { List <ATTMessageReceiver> lstMsgReciever = new List <ATTMessageReceiver>(); foreach (DataRow row in tblMsgReceiver.Rows) { bool flag = false; if (type == "IN") { if (orgID == int.Parse(row["ORG_ID"].ToString()) && messageID == int.Parse(row["MSG_ID"].ToString()) && msgSeq == int.Parse(row["MSG_SEQ"].ToString()) ) { flag = true; } } else { if (orgID == int.Parse(row["ORG_ID"].ToString()) && messageID == int.Parse(row["MSG_ID"].ToString()) ) { flag = true; } } if (flag) { ATTMessageReceiver objMsgReceiver = new ATTMessageReceiver(); objMsgReceiver.OrgID = int.Parse(row["ORG_ID"].ToString()); objMsgReceiver.MessageID = int.Parse(row["MSG_ID"].ToString()); objMsgReceiver.IsGrpReceiver = row["IS_GRP_RECEIVER"].ToString(); if (objMsgReceiver.IsGrpReceiver.Trim() == "Y") { if (row["GRP_ORG_ID"].ToString() != "") { objMsgReceiver.ReceiverOrgID = int.Parse(row["GRP_ORG_ID"].ToString()); } else { objMsgReceiver.ReceiverOrgID = null; } if (row["GRP_ID"].ToString() != "") { objMsgReceiver.GroupID = int.Parse(row["GRP_ID"].ToString()); } else { objMsgReceiver.GroupID = null; } if (row["GRP_RECEIVER_ID"].ToString() != "") { objMsgReceiver.ReceiverID = int.Parse(row["GRP_RECEIVER_ID"].ToString()); } else { objMsgReceiver.ReceiverID = null; } if (row["GRP_FROM_DATE"].ToString() != "") { objMsgReceiver.GrpFromDate = row["GRP_FROM_DATE"].ToString(); } objMsgReceiver.Receiver = row["R_FIRST_NAME"].ToString() + (row["R_MID_NAME"].ToString() == "" ? " " : row["R_MID_NAME"].ToString()) + (row["R_SUR_NAME"].ToString() == "" ? " " : row["R_SUR_NAME"].ToString()); } else if (objMsgReceiver.IsGrpReceiver.Trim() == "N") { if (row["OTHER_RECEIVER_ID"].ToString() != "") { objMsgReceiver.OtherReceiverID = int.Parse(row["OTHER_RECEIVER_ID"].ToString()); } else { objMsgReceiver.OtherReceiverID = null; } objMsgReceiver.ReceiverOrgID = null; objMsgReceiver.GroupID = null; objMsgReceiver.ReceiverID = null; objMsgReceiver.GrpFromDate = null; objMsgReceiver.OtherReceiver = row["R_FIRST_NAME"].ToString() + (row["R_MID_NAME"].ToString() == "" ? " " : row["R_MID_NAME"].ToString()) + (row["R_SUR_NAME"].ToString() == "" ? " " : row["R_SUR_NAME"].ToString()); } objMsgReceiver.Read = row["READ"].ToString(); objMsgReceiver.Action = "N"; objMsg.Read = objMsgReceiver.Read; lstMsgReciever.Add(objMsgReceiver); } } return(lstMsgReciever); }
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(); } }