public ActionResult NotificationTickets()
{
try
{
Domain.Socioboard.Domain.User objuser = (Domain.Socioboard.Domain.User)Session["User"];
DataSet ds = null;
clsFeedsAndMessages clsfeedsandmess = new clsFeedsAndMessages();
ds = clsfeedsandmess.bindMyTickets(objuser.Id);
if (ds.Tables.Count > 0 && ds != null)
{
return(PartialView("_TicketsNotificationPartial", ds));
}
else
{
return(Content("nodata"));
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(Content("SomethingWentWrong"));
}
}
public DataSet bindMessages()
{
DataSet ds = null;
DataSet dataset = new DataSet();
clsFeedsAndMessages clsfeedsandmess = new clsFeedsAndMessages();
string[] profid = new string[] { };
Domain.Socioboard.Domain.Team team = SBUtils.GetTeamFromGroupId();
try
{
string message = string.Empty;
try
{
profid = Request.QueryString["profileid[]"].Split(',');
if (Request.QueryString["type"] != null)
{
Session["countMesageDataTable_" + profid] = null;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
string facebook = string.Empty;
foreach (var item in profid)
{
if (string.IsNullOrEmpty(item))
{
facebook = "emptyprofile";
}
else
{
facebook = "profile";
}
}
if (string.IsNullOrEmpty(facebook))
{
facebook = "emptyprofile";
}
//if (facebook == "emptyprofile")
{
try
{
//DataSet ds = null;
Session["countMesageDataTable_" + profid] = null;
if (facebook == "emptyprofile")
{
ds = clsfeedsandmess.bindMessagesIntoDataTable(team.Id);
}
else
{
ds = clsfeedsandmess.bindFeedMessageIntoDataTable(profid);
}
//FacebookFeedRepository fbFeedRepo = new FacebookFeedRepository();
Session["MessageDataTable"] = ds;
ds = (DataSet)Session["MessageDataTable"];
if (Session["countMessageDataTable"] == null)
{
Session["countMessageDataTable"] = 0;
}
int noOfDataToSkip = (int)Session["countMessageDataTable"];
DataTable records = ds.Tables[0].Rows.Cast <System.Data.DataRow>().Skip(noOfDataToSkip).Take(noOfDataToSkip + 15).CopyToDataTable();
Session["countMessageDataTable"] = noOfDataToSkip + 15;
//message = this.BindData(records);
dataset.Tables.Add(records);
return(dataset);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
//else
//{
// try
// {
// DataSet ds = null;
// Session["countMessageDataTable"] = null;
// ds = clsfeedsandmess.bindFeedMessageIntoDataTable(profid);
// Session["MessageDataTable"] = ds;
// ds = (DataSet)Session["MessageDataTable"];
// if (Session["countMesageDataTable_" + profid] == null)
// {
// Session["countMesageDataTable_" + profid] = 0;
// }
// int noOfDataToSkip = (int)Session["countMesageDataTable_" + profid];
// DataTable records = ds.Tables[0].Rows.Cast<System.Data.DataRow>().Skip(noOfDataToSkip).Take(noOfDataToSkip + 15).CopyToDataTable();
// Session["countMesageDataTable_" + profid] = noOfDataToSkip + 15;
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.StackTrace);
// }
//}
//if (string.IsNullOrEmpty(message))
//{
//}
//Response.Write(message);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
return(dataset);
}
//Commented by SumitGupta [09-02-2015]
//public DataSet bindMessages()
//{
// Domain.Socioboard.Domain.User _user = (Domain.Socioboard.Domain.User)Session["User"];
// DataSet ds = null;
// DataSet dataset = new DataSet();
// clsFeedsAndMessages clsfeedsandmess = new clsFeedsAndMessages();
// //string[] profid = new string[] { };
// string[] profid = (string[])Session["ProfileSelected"];
// Domain.Socioboard.Domain.Team team = SBUtils.GetTeamFromGroupId();
// try
// {
// string message = string.Empty;
// try
// {
// //if (profid != null)
// //{
// //profid = Request.QueryString["profileid[]"].Split(',');
// //if (Request.QueryString["type"] != null)
// //{
// Session["countMesageDataTable_" + profid] = null;
// //}
// //}
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.StackTrace);
// }
// string facebook = string.Empty;
// foreach (var item in profid)
// {
// if (string.IsNullOrEmpty(item))
// {
// facebook = "emptyprofile";
// }
// else
// {
// facebook = "profile";
// }
// }
// if (string.IsNullOrEmpty(facebook))
// {
// facebook = "emptyprofile";
// }
// //if (facebook == "emptyprofile")
// {
// try
// {
// //DataSet ds = null;
// Session["countMesageDataTable_" + profid] = null;
// if (facebook == "emptyprofile")
// {
// ds = clsfeedsandmess.bindMessagesIntoDataTable(team.Id);
// }
// else
// {
// ds = clsfeedsandmess.bindFeedMessageIntoDataTable(profid);
// }
// //FacebookFeedRepository fbFeedRepo = new FacebookFeedRepository();
// Session["MessageDataTable"] = ds;
// ds = (DataSet)Session["MessageDataTable"];
// if (Session["countMessageDataTable"] == null)
// {
// Session["countMessageDataTable"] = 0;
// }
// int noOfDataToSkip = (int)Session["countMessageDataTable"];
// //DataTable records = ds.Tables[0].Rows.Cast<System.Data.DataRow>().Skip(noOfDataToSkip).Take(noOfDataToSkip + 15).CopyToDataTable();
// DataTable records = ds.Tables[0].Rows.Cast<System.Data.DataRow>().Skip(noOfDataToSkip).Take(15).CopyToDataTable();
// Session["countMessageDataTable"] = noOfDataToSkip + 15;
// //message = this.BindData(records);
// dataset.Tables.Add(records);
// return dataset;
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.StackTrace);
// }
// }
// //else
// //{
// // try
// // {
// // DataSet ds = null;
// // Session["countMessageDataTable"] = null;
// // ds = clsfeedsandmess.bindFeedMessageIntoDataTable(profid);
// // Session["MessageDataTable"] = ds;
// // ds = (DataSet)Session["MessageDataTable"];
// // if (Session["countMesageDataTable_" + profid] == null)
// // {
// // Session["countMesageDataTable_" + profid] = 0;
// // }
// // int noOfDataToSkip = (int)Session["countMesageDataTable_" + profid];
// // DataTable records = ds.Tables[0].Rows.Cast<System.Data.DataRow>().Skip(noOfDataToSkip).Take(noOfDataToSkip + 15).CopyToDataTable();
// // Session["countMesageDataTable_" + profid] = noOfDataToSkip + 15;
// // }
// // catch (Exception ex)
// // {
// // Console.WriteLine(ex.StackTrace);
// // }
// //}
// //if (string.IsNullOrEmpty(message))
// //{
// //}
// //Response.Write(message);
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.StackTrace);
// }
// return dataset;
//}
//Updated by SumitGupta [09-02-2015]
public DataSet bindMessages()
{
Domain.Socioboard.Domain.User _user = (Domain.Socioboard.Domain.User)Session["User"];
DataSet ds = null;
DataSet dataset = new DataSet();
clsFeedsAndMessages clsfeedsandmess = new clsFeedsAndMessages();
//string[] profid = new string[] { };
string[] profid = (string[])Session["ProfileSelected"];
Domain.Socioboard.Domain.Team team = SBUtils.GetTeamFromGroupId();
try
{
//For getting data range
Session["MessageDataTable"] = ds;
ds = (DataSet)Session["MessageDataTable"];
if (Session["countMessageDataTable"] == null)
{
Session["countMessageDataTable"] = 0;
}
int noOfDataToSkip = (int)Session["countMessageDataTable"];
//DataTable records = ds.Tables[0].Rows.Cast<System.Data.DataRow>().Skip(noOfDataToSkip).Take(15).CopyToDataTable();
Session["countMessageDataTable"] = noOfDataToSkip + 15;
string message = string.Empty;
try
{
//if (profid != null)
//{
//profid = Request.QueryString["profileid[]"].Split(',');
//if (Request.QueryString["type"] != null)
//{
Session["countMesageDataTable_" + profid] = null;
//}
//}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
string facebook = string.Empty;
foreach (var item in profid)
{
if (string.IsNullOrEmpty(item))
{
facebook = "emptyprofile";
}
else
{
facebook = "profile";
}
}
if (string.IsNullOrEmpty(facebook))
{
facebook = "emptyprofile";
}
//if (facebook == "emptyprofile")
{
try
{
//DataSet ds = null;
Session["countMesageDataTable_" + profid] = null;
if (facebook == "emptyprofile")
{
//Updated by SumitGupta [09-02-2015]
//ds = clsfeedsandmess.bindMessagesIntoDataTable(team.Id);
ds = clsfeedsandmess.bindMessagesIntoDataTable(team.Id, noOfDataToSkip, _user.Id);
}
else
{
//Updated by SumitGupta [09-02-2015]
//ds = clsfeedsandmess.bindFeedMessageIntoDataTable(profid);
ds = clsfeedsandmess.bindFeedMessageIntoDataTable(profid, noOfDataToSkip, _user.Id);
}
Session["MessageDataTable"] = ds;
ds = (DataSet)Session["MessageDataTable"];
if (Session["countMessageDataTable"] == null)
{
Session["countMessageDataTable"] = 0;
}
//Updated by Sumit Gupta [09-02-2015]
//dataset.Tables.Add(records);
//return dataset;
return(ds);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
//else
//{
// try
// {
// DataSet ds = null;
// Session["countMessageDataTable"] = null;
// ds = clsfeedsandmess.bindFeedMessageIntoDataTable(profid);
// Session["MessageDataTable"] = ds;
// ds = (DataSet)Session["MessageDataTable"];
// if (Session["countMesageDataTable_" + profid] == null)
// {
// Session["countMesageDataTable_" + profid] = 0;
// }
// int noOfDataToSkip = (int)Session["countMesageDataTable_" + profid];
// DataTable records = ds.Tables[0].Rows.Cast<System.Data.DataRow>().Skip(noOfDataToSkip).Take(noOfDataToSkip + 15).CopyToDataTable();
// Session["countMesageDataTable_" + profid] = noOfDataToSkip + 15;
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.StackTrace);
// }
//}
//if (string.IsNullOrEmpty(message))
//{
//}
//Response.Write(message);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
return(dataset);
}