protected void GetMessgeDetail() { dt = new DataTable(); Int32 MsgId = Convert.ToInt32(Request.QueryString["MsgId"]); dt = clsMessage.SelectMsgDetailforSentPartyListExt(MsgId); if (dt.Rows.Count > 0) { if (Convert.ToString(dt.Rows[0]["PartyId"]) != "") { String ToList = ""; int i = 0; foreach (DataRow DR in dt.Rows) { if (i >= 1) { ToList = ToList + " , " + DR["compname"].ToString(); } if (i == 0) { ToList = DR["compname"].ToString(); i = 1; } } lblto.Text = ToList; } } else { SqlDataAdapter da = new SqlDataAdapter("SELECT " + PageConn.extmsg11 + ".dbo.MsgMasterExt.MsgDate," + PageConn.extmsg11 + ".dbo.MsgMasterExt.FromEmail, " + PageConn.extmsg11 + ".dbo.MsgMasterExt.MsgSubject, " + PageConn.extmsg11 + ".dbo.MsgMasterExt.FromPartyId, " + PageConn.extmsg11 + ".dbo.MsgMasterExt.MsgId, " + PageConn.extmsg11 + ".dbo.MsgMasterExt.MsgStatus, " + PageConn.extmsg11 + ".dbo.MsgDetailExt.MsgDetailId FROM " + PageConn.extmsg11 + ".dbo.MsgDetailExt INNER JOIN " + PageConn.extmsg11 + ".dbo.MsgMasterExt ON " + PageConn.extmsg11 + ".dbo.MsgDetailExt.MsgId = " + PageConn.extmsg11 + ".dbo.MsgMasterExt.MsgId INNER JOIN " + PageConn.extmsg11 + ".dbo.MsgStatusMasterExt ON " + PageConn.extmsg11 + ".dbo.MsgDetailExt.MsgStatusId = " + PageConn.extmsg11 + ".dbo.MsgStatusMasterExt.MsgStatusId WHERE (" + PageConn.extmsg11 + ".dbo.MsgMasterExt.MsgId = '" + MsgId + "') AND (" + PageConn.extmsg11 + ".dbo.MsgMasterExt.MsgStatus <> 'Deleted' OR " + PageConn.extmsg11 + ".dbo.MsgMasterExt.MsgStatus IS NULL) AND (" + PageConn.extmsg11 + ".dbo.MsgDetailExt.MsgStatusId NOT IN (3))", con); da.Fill(dt); lblto.Text = dt.Rows[0]["FromEmail"].ToString(); } Int32 MsgDetailId = Convert.ToInt32(dt.Rows[0]["MsgDetailId"].ToString()); dt = new DataTable(); dt = clsMessage.SelectMsgforDetailExt(MsgDetailId); if (dt.Rows.Count > 0) { lblFrom.Text = dt.Rows[0]["partyname"].ToString(); lblsubject.Text = dt.Rows[0]["MsgSubject"].ToString(); lblmessage.Text = dt.Rows[0]["MsgDetail"].ToString(); lbldate.Text = dt.Rows[0]["MsgDate"].ToString(); } }
protected void grdSentMailList_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { Int32 MsgId = 0; DataTable dtMain = new DataTable(); MsgId = Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "MsgId").ToString()); // dtMain = new DataTable(); dtMain = clsMessage.SelectMsgDetailforSentPartyListExt(MsgId); Label sentTo = (Label)e.Row.FindControl("lblSentTo"); if (dtMain.Rows.Count > 0) { String ToList = ""; int i = 0; foreach (DataRow DR in dtMain.Rows) { if (i >= 1) { ToList = ToList + " , " + DR["Compname"].ToString(); } if (i == 0) { ToList = DR["Compname"].ToString(); i = 1; } if (ToList.Length > 25) { ToList = ToList + " ...."; break; } } sentTo.Text = ToList.ToString(); } else { SqlDataAdapter daaaa = new SqlDataAdapter("select ToEmailID from " + PageConn.extmsg11 + ".dbo.MsgDetailExt where MsgId='" + MsgId + "'", con); DataTable dtaaa = new DataTable(); daaaa.Fill(dtaaa); if (dtaaa.Rows.Count > 0) { sentTo.Text = Convert.ToString(dtaaa.Rows[0]["ToEmailID"]); } } dtMain = new DataTable(); dtMain = clsMessage.SelectMsgforFileAttachExt(MsgId); Image img = (Image)e.Row.FindControl("ImgFile"); if (dtMain.Rows.Count > 0) { img.ImageUrl = "~/Account/images/attach.png"; img.Visible = true; } else { img.ImageUrl = ""; img.Visible = false; } } try { if (grdSentMailList.Rows.Count > 0) { CheckBox cbHeader = (CheckBox)grdSentMailList.HeaderRow.FindControl("HeaderChkbox"); cbHeader.Attributes["onclick"] = "ChangeAllCheckBoxStates(this.checked);"; List <string> ArrayValues = new List <string>(); ArrayValues.Add(string.Concat("'", cbHeader.ClientID, "'")); foreach (GridViewRow gvr in grdSentMailList.Rows) { CheckBox cb = (CheckBox)gvr.FindControl("chkMsg"); cb.Attributes["onclick"] = "ChangeHeaderAsNeeded();"; ArrayValues.Add(string.Concat("'", cb.ClientID, "'")); } CheckBoxIDsArray.Text = "<script type='text/javascript'>" + "\n" + "<!--" + "\n" + String.Concat("var CheckBoxIDs = new Array(", String.Join(",", ArrayValues.ToArray()), ");") + "\n // -->" + "\n" + "</script>"; } else { } } catch (Exception ex) { pnlmsg.Visible = true; lblmsg.Text = "Error in databound : " + ex.Message.ToString(); } }