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