private void BindGridData()
{
EWA_Messages objEWA = new EWA_Messages();
BL_Messages objBL = new BL_Messages();
objEWA.OrgId = Session["OrgId"].ToString();
objEWA.FacultyId = Session["UserCode"].ToString();
objEWA.Action = "FetchStaffMessage";
ds = objBL.BindGrdViewAnnouncement_BL(objEWA);
if (ds.Tables[0].Rows.Count == 0)
{
GrdViewAnnouncement.DataSource = ReturnEmptyDataTable();
GrdViewAnnouncement.DataBind();
GrdViewAnnouncement.Columns[3].Visible = false;
GrdViewAnnouncement.Rows[0].Cells[0].ColumnSpan = 3;
GrdViewAnnouncement.Rows[0].Cells[1].Visible = false;
GrdViewAnnouncement.Rows[0].Cells[2].Visible = false;
lblNoMessageFound.Visible = true;
}
else
{
// GrdViewAnnouncement.DataSource = db.Displaygrid(" SELECT DISTINCT ms.MessageId, md.StaffUserCode, er.FirstName + ' ' + er.MiddleName + ' ' + er.LastName AS 'Sender', ms.Subject, CONVERT(varchar, md.SendDate, 107) AS 'SendDate', ms.MessageContent FROM tblMessageSave AS ms INNER JOIN tblEmployee AS er ON ms.StaffUserCode = er.UserCode INNER JOIN tblMessageDetails AS md ON ms.MessageId = md.MessageId WHERE (ms.MessageId IN (SELECT MessageId FROM tblMessageDetails WHERE (StaffUserCode = '" + objEWA.FacultyId + "'))) AND (ms.OrgId = '" + objEWA.OrgId + "') ");
GrdViewAnnouncement.DataSource = db.Displaygrid(" SELECT DISTINCT ms.MessageId, md.StaffUserCode, er.FirstName + ' ' + er.MiddleName + ' ' + er.LastName AS 'Sender', ms.Subject, CONVERT(varchar, md.SendDate, 107) AS 'SendDate', ms.MessageContent FROM tblMessageSave AS ms INNER JOIN tblMessageDetails AS md ON ms.MessageId = md.MessageId INNER JOIN tblEmployee AS er ON ms.StaffUserCode = er.UserCode WHERE (ms.MessageId IN (SELECT MessageId FROM tblMessageDetails WHERE (StaffUserCode = '" + objEWA.FacultyId + "'))) AND (md.StaffUserCode = '" + objEWA.FacultyId + "') AND (ms.OrgId = '" + objEWA.OrgId + "') ORDER BY ms.MessageId DESC ");
GrdViewAnnouncement.DataBind();
// GrdViewAnnouncement.DataBind();
dsGrdViewAnnouncement = ds.Copy();
}
}
protected void BindGridData()
{
EWA_Messages objEWA = new EWA_Messages();
BL_Messages objBL = new BL_Messages();
objEWA.OrgId = Session["OrgId"].ToString();
objEWA.StudentId = Session["UserCode"].ToString();
objEWA.Action = "FetchStudentMessage";
ds = objBL.BindGrdViewAnnouncement_BL(objEWA);
//SqlCommand cmd1 = new SqlCommand(" SELECT DISTINCT ms.MessageId, er.FirstName + ' ' + er.MiddleName + ' ' + er.LastName AS 'Sender', ms.Subject, CONVERT(varchar, md.SendDate, 107) AS 'SendDate', ms.MessageContent, md.StudentUserCode FROM tblMessageSave AS ms INNER JOIN tblEmployee AS er ON ms.StaffUserCode = er.UserCode INNER JOIN tblMessageDetails AS md ON ms.MessageId = md.MessageId WHERE (ms.MessageId IN (SELECT MessageId FROM tblMessageDetails WHERE (StudentUserCode = '" + objEWA.StudentId + "'))) AND (ms.OrgId = '" + objEWA.OrgId + "') AND (md.StudentUserCode = '" + objEWA.StudentId + "') order by (MessageId) desc", cn);
//SqlDataAdapter adp1 = new SqlDataAdapter();
//DataSet ds1 = new DataSet();
//adp1.SelectCommand = cmd1;
//adp1.Fill(ds1);
if (ds.Tables[0].Rows.Count == 0)
{
GrdViewAnnouncement.DataSource = ReturnEmptyDataTable();
GrdViewAnnouncement.DataBind();
GrdViewAnnouncement.Columns[3].Visible = false;
GrdViewAnnouncement.Rows[0].Cells[0].ColumnSpan = 3;
GrdViewAnnouncement.Rows[0].Cells[1].Visible = false;
GrdViewAnnouncement.Rows[0].Cells[2].Visible = false;
lblNoMessageFound.Visible = true;
}
else
{
GrdViewAnnouncement.DataSource = ds;
GrdViewAnnouncement.DataBind();
dsGrdViewAnnouncement = ds.Copy();
}
}
