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 GrdViewAnnouncement_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
try
{
GrdViewAnnouncement.PageIndex = e.NewPageIndex;
GrdViewAnnouncement.DataSource = dsGrdViewAnnouncement;
GrdViewAnnouncement.DataBind();
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
// string searchfeild = Empsearch.Text;
string OrgId = Session["OrgId"].ToString();
string FacultyId = Session["UserCode"].ToString();
DataSet ds = new DataSet();
strCon.Close();
strCon.Open();
using (SqlCommand cmd = new SqlCommand("select distinct ms.MessageId,md.StaffUserCode,er.FirstName+' '+er.MiddleName+' '+er.LastName as 'Sender',[Subject],convert(varchar,SendDate,107) as 'SendDate',ms.MessageContent from tblMessageSave ms, tblMessageDetails md, tblEmployee er where ms.StaffUserCode = er.UserCode and ms.MessageId = md.MessageId and ms.MessageId IN(Select MessageId from tblMessageDetails where StaffUserCode = 1005) and md.StaffUserCode = 1005 and ms.OrgId = 1 ander.FirstName like 'Admin%' order by(ms.MessageId) desc ", strCon))
{
cmd.CommandType = CommandType.Text;
cmd.Connection = strCon;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(ds);
}
//GrdViewAnnouncement.DataSource = db.Displaygrid("select distinct ms.MessageId,md.StaffUserCode,er.FirstName+' '+er.MiddleName+' '+er.LastName as 'Sender',[Subject],convert(varchar,SendDate,107) as 'SendDate',ms.MessageContent from tblMessageSave ms, tblMessageDetails md, tblEmployee er where ms.StaffUserCode = er.UserCode and ms.MessageId = md.MessageId and ms.MessageId IN(Select MessageId from tblMessageDetails where StaffUserCode = 1005) and md.StaffUserCode = 1005 and ms.OrgId = 1 ander.FirstName like 'Admin%' order by(ms.MessageId) desc ");
GrdViewAnnouncement.DataSource = ds;
GrdViewAnnouncement.DataBind();
}
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();
}
}
