private void GetNotes()
{
try
{
objProjectCls = new ProjectClass();
string sProjId = (string)(Session["projId"]);
string sLogisticCompany = objProjectCls.GetLogisticCompany(sProjId);
objProjectCls.NotesHandle = "T_ERECTIONACTIVITY_" + sLogisticCompany + "";
objProjectCls.AttachmentHandle = "T_ERECTIONACTIVITY_" + sLogisticCompany + "";
objProjectCls.IndexValue = hdfNoteId.Value;
//DataTable dt = objProjectCls.GetNotesFromASPNETUSer();
DataTable dt = objProjectCls.GetNotes();
if (dt.Rows.Count > 0)
{
rptNotes.DataSource = dt;
rptNotes.DataBind();
}
else
{
//ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('No record found');", true);
}
// DataTable dtAttach = objProjectCls.GetAllAttachments();
DataTable dtAttach = objProjectCls.GetAttachments();
if (dtAttach.Rows.Count > 0)
{
gvAttachment.DataSource = dtAttach;
gvAttachment.DataBind();
divNoRecord.Visible = false;
divViewAttachment.Visible = true;
}
else
{
divNoRecord.Visible = true;
divViewAttachment.Visible = false;
}
}
catch (Exception ex)
{
}
}
private void BindData()
{
try
{
DataTable dt = new DataTable();
string sUsername = (string)(Session["Username"]);
// sUsername = "******";// for testing only
//if (Request.QueryString["user"] != null)
if (sUsername != null)
{
objProjectCls = new ProjectClass();
string sProjId = (string)(Session["projId"]);
string sLogisticCompany = objProjectCls.GetLogisticCompany(sProjId);
objProjectCls.IndexValue = hdfNoteId.Value;
objProjectCls.AttachmentHandle = "T_ERECTIONACTIVITY_" + sLogisticCompany + "";
dt = objProjectCls.GetAttachments();
if (dt.Rows.Count > 0)
{
gvAttachment.DataSource = dt;
gvAttachment.DataBind();
divNoRecord.Visible = false;
divViewAttachment.Visible = true;
}
else
{
divNoRecord.Visible = true;
divViewAttachment.Visible = false;
}
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('No Data found');", true);
}
}
catch (System.Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('Due to some technical issue record not found');", true);
}
}