public void GetActivityData()
{
DataTable dtGridViewActivity;
dtGridViewActivity = objBSS.GetActivitySales(Session["UserID"].ToString());
if (dtGridViewActivity.Rows.Count > 0)
{
DataTable dt1 = new DataTable();
dt1.Columns.AddRange(new DataColumn[]
{
new DataColumn("Subject"),
new DataColumn("Customer"),
new DataColumn("RefID"),
new DataColumn("POC"),
new DataColumn("POCName"),
new DataColumn("Address"),
new DataColumn("OppName"),
new DataColumn("SubRefID"),
new DataColumn("ActivityName"),
new DataColumn("ActivityTypeID"),
new DataColumn("Date"),
new DataColumn("Time"),
new DataColumn("ActivityStatus"),
new DataColumn("ActivityStatusID"),
new DataColumn("ActivityOwner"),
new DataColumn("ActivityOwnerID"),
new DataColumn("ClosureRemarks"),
new DataColumn("ClosureRemarksID"),
new DataColumn("Attachment"),
new DataColumn("Remarks"),
new DataColumn("ActivityID"),
new DataColumn("TransactionBy")
});
for (int i = 0; i <= dtGridViewActivity.Rows.Count - 1; i++)
{
dt1.Rows.Add(dtGridViewActivity.Rows[i]["Subject"].ToString(),
dtGridViewActivity.Rows[i]["Customer"].ToString(),
dtGridViewActivity.Rows[i]["RefID"].ToString(),
dtGridViewActivity.Rows[i]["POC"].ToString(),
dtGridViewActivity.Rows[i]["POCName"].ToString(),
dtGridViewActivity.Rows[i]["Address"].ToString(),
dtGridViewActivity.Rows[i]["OppName"].ToString(),
dtGridViewActivity.Rows[i]["SubRefID"].ToString(),
dtGridViewActivity.Rows[i]["ActivityName"].ToString(),
dtGridViewActivity.Rows[i]["ActivityTypeID"].ToString(),
dtGridViewActivity.Rows[i]["Date"].ToString(),
dtGridViewActivity.Rows[i]["Time"].ToString(),
dtGridViewActivity.Rows[i]["ActivityStatus"].ToString(),
dtGridViewActivity.Rows[i]["ActivityStatusID"].ToString(),
dtGridViewActivity.Rows[i]["ActivityOwner"].ToString(),
dtGridViewActivity.Rows[i]["ActivityOwnerID"].ToString(),
dtGridViewActivity.Rows[i]["ClosureRemarks"].ToString(),
dtGridViewActivity.Rows[i]["ClosureRemarksID"].ToString(),
dtGridViewActivity.Rows[i]["Attachment"].ToString(),
dtGridViewActivity.Rows[i]["Remarks"].ToString(),
dtGridViewActivity.Rows[i]["ActivityID"].ToString(),
dtGridViewActivity.Rows[i]["TransactionBy"].ToString()
);
}
GVActivity.DataSource = dt1;
GVActivity.DataBind();
GVActivity.MasterTableView.GetColumn("RefID").Visible = false;
GVActivity.MasterTableView.GetColumn("POC").Visible = false;
GVActivity.MasterTableView.GetColumn("Address").Visible = false;
GVActivity.MasterTableView.GetColumn("SubRefID").Visible = false;
GVActivity.MasterTableView.GetColumn("ActivityTypeID").Visible = false;
GVActivity.MasterTableView.GetColumn("Time").Visible = false;
GVActivity.MasterTableView.GetColumn("ActivityStatusID").Visible = false;
GVActivity.MasterTableView.GetColumn("ActivityOwner").Visible = false;
GVActivity.MasterTableView.GetColumn("ActivityOwnerID").Visible = false;
GVActivity.MasterTableView.GetColumn("ClosureRemarksID").Visible = false;
GVActivity.MasterTableView.GetColumn("Attachment").Visible = false;
GVActivity.MasterTableView.GetColumn("Remarks").Visible = false;
GVActivity.MasterTableView.GetColumn("ActivityID").Visible = false;
}
}