public string GetStarredComments()
{
CFSession CFSess = (CFSession)Session["CFSess"];
string UID = CFSess.ID;
return(JsonConvert.SerializeObject(BALPost.GetStarredComments(UID)));
}
public string SendInvitaion(string FName, string LName, string Email, string Desc)
{
string Content = FCommon.GetEmailTemplateBody("Invitation.txt");
//Content = Content.Replace("@Logo", "<img src='http://www.salamislam.com/sites/default/files/video_poster/Eid-ul-Fitr-2013.-India-2.jpg'>");
////FCommon.SendEmail("*****@*****.**", "", "Tresmark Talk Chat", Content);
//FCommon.SendEmail("*****@*****.**", Email, "Invitation", Content);
CFSession CFSess = (CFSession)Session["CFSess"];
string Fasih = HttpUtility.UrlEncode(FCommon.Encrypt("ToID:" + ((CFSession)Session["CFSess"]).ID + "~ToEmail:" + Email + "~FName:" + FName + "~LName:" + LName + "~Desc:" + Desc));
string link = "http://175.107.202.227:8080/Account/Login?q=" + Fasih;
Content = Content.Replace("@Link", link);
Content = Content.Replace("@MyName", CFSess.FirstName + " " + CFSess.LastName);
Content = Content.Replace("@UserName", FName + " " + LName);
Content = Content.Replace("@Note", Desc);
if (Desc != "")
{
Content = Content.Replace("@DisplayNote", "block");
}
else
{
Content = Content.Replace("@DisplayNote", "none");
}
if (FCommon.SendEmail("*****@*****.**", Email, "Invitation", Content))
{
return(JsonConvert.SerializeObject(BALUser.InsertUpdateInvitation(((CFSession)Session["CFSess"]).ID, Email, 0)));
}
return(JsonConvert.SerializeObject(""));
}
public string InsertPost(string Title, string Category, string Body, string FileName, string FileGeneratedName)
{
//System.Threading.Thread.Sleep(20000);
if (Category == "" || Category == null)
{
Category = "1";
}
CFSession CFSess = (CFSession)Session["CFSess"];
BALPost.ID = 0;
BALPost.UserID = Convert.ToInt32(CFSess.ID);
BALPost.Title = Title;
BALPost.CategoryID = Convert.ToInt32(Category);
BALPost.Body = Body;
BALPost.IsPublic = true;
BALPost.IsActive = true;
BALPost.OrignalName = FileName;
BALPost.GeneratedName = FileGeneratedName;
DataRow dr = BALPost.InsertUpdatePosts(BALPost, "0", "10");
if (dr != null)
{
var hubContext = GlobalHost.ConnectionManager.GetHubContext <GeneralHub>();
hubContext.Clients.All.setPost(dr);
}
return(JsonConvert.SerializeObject(dr));
}
public string InsertTeamMember(string TeamID)
{
//System.Threading.Thread.Sleep(3000);
CFSession CFSess = (CFSession)Session["CFSess"];
return(JsonConvert.SerializeObject(BAL.InsertTeamMember(Convert.ToInt32(TeamID), Convert.ToInt32(CFSess.ID), 2, DateTime.Now)));
}
public string DeletePost(string RefID)
{
CFSession CFSess = (CFSession)Session["CFSess"];
DataTable dt = BALPost.InactivePost(CFSess.ID, RefID, false);
return(JsonConvert.SerializeObject(dt));
}
public string GetCommentsByCount(string ID, string RefID, string RefType, string Offset, string Next)
{
//System.Threading.Thread.Sleep(20000);
CFSession CFSess = (CFSession)Session["CFSess"];
return(JsonConvert.SerializeObject(BALPost.GetCommentsByCount(CFSess.ID, ID, RefID, RefType, Offset, Next)));
}
public string Login(string Email, string Password)
{
DataRow dr = BALUser.LoginAuthentication(Email, Password);
if (dr["ID"].ToString().Equals("0"))
{
}
else
{
if (dr["IsActive"].ToString().Equals("True"))
{
CFSession Sess = new CFSession();
Sess.ID = dr["ID"].ToString();
Sess.FirstName = dr["FirstName"].ToString();
Sess.LastName = dr["LastName"].ToString();
Sess.ImageUrl = dr["ImageUrl"].ToString();
Sess.fk_UserTypeID = Convert.ToInt32(dr["fk_UserTypeID"]);
Sess.IsFirstLogin = Convert.ToBoolean(dr["IsFirstLogin"]);
Session["CFSess"] = Sess;
}
else
{
}
}
return(JsonConvert.SerializeObject(dr));
}
public string GetPostDetails(string RefID)
{
CFSession CFSess = (CFSession)Session["CFSess"];
DataTable dt = BALPost.GetPostDetails(Convert.ToInt32(RefID));
return(JsonConvert.SerializeObject(dt));
}
public string UpdateUserDescriptions()
{
CFSession CFSess = (CFSession)Session["CFSess"];
int UserID = Convert.ToInt32(CFSess.ID);
CFSess.IsFirstLogin = false;
Session["CFSess"] = CFSess;
return(JsonConvert.SerializeObject(BALUser.IsFirstLogin(UserID)));
}
public string UpdateComment(string ID, string RefID, string RefType, string Body)
{
CFSession CFSess = (CFSession)Session["CFSess"];
DataTable dr = BALPost.InsertUpdateComment(ID, CFSess.ID, RefID, RefType, Body, true, "", "");
if (dr != null)
{
var hubContext = GlobalHost.ConnectionManager.GetHubContext <GeneralHub>();
hubContext.Clients.All.editComment(dr);
}
return(JsonConvert.SerializeObject(dr));
}
public string InsertCommentAttachment(string RefID, string Title, string Description, string FileName, string FileGeneratedName)
{
CFSession CFSess = (CFSession)Session["CFSess"];
DataTable dr = BALPost.InsertUpdateCommentAttachment("", CFSess.ID, RefID, Title, Description, true, FileName, FileGeneratedName);
if (dr != null)
{
var hubContext = GlobalHost.ConnectionManager.GetHubContext <GeneralHub>();
hubContext.Clients.All.setComment(dr);
}
return(JsonConvert.SerializeObject(dr));
}
public string DeleteComment(string ID)
{
CFSession CFSess = (CFSession)Session["CFSess"];
DataTable dr = BALPost.UpdateCommentStatus(ID, false);
if (dr != null)
{
var hubContext = GlobalHost.ConnectionManager.GetHubContext <GeneralHub>();
hubContext.Clients.All.deleteComments(dr);
}
return(JsonConvert.SerializeObject(dr));
}
public string UserOnConnect(string ConnectionID)
{
CFSession CFSess = (CFSession)Session["CFSess"];
var hubContext = GlobalHost.ConnectionManager.GetHubContext <GeneralHub>();
//if (!UserConnIDs.DConnIds.ContainsValue(CFSess.ID))
// hubContext.Clients.All.setUserOnlineOffline(CFSess.ID, "Online");
UserConnIDs.DConnIds.Add(ConnectionID, CFSess.ID);
return(JsonConvert.SerializeObject(""));
//CFSession CFSess = (CFSession)Session["CFSess"];
//return Convert.ToInt32(CFSess.ID);
}
public string InsertCommentFlag(string RefID)
{
//System.Threading.Thread.Sleep(10000);
CFSession CFSess = (CFSession)Session["CFSess"];
DataTable dr = BALPost.InsertDeleteCommentFlagged(CFSess.ID, RefID);
if (dr != null)
{
var hubContext = GlobalHost.ConnectionManager.GetHubContext <GeneralHub>();
hubContext.Clients.All.setCommentFlagged(dr);
}
return(JsonConvert.SerializeObject(dr));
}
public string InsertCommentSupportOppose(string RefID, string type)
{
//System.Threading.Thread.Sleep(10000);
CFSession CFSess = (CFSession)Session["CFSess"];
DataTable dr = BALPost.InsertSupportOppose(Convert.ToInt32(CFSess.ID), Convert.ToInt32(RefID), Convert.ToBoolean(type));
if (dr != null)
{
var hubContext = GlobalHost.ConnectionManager.GetHubContext <GeneralHub>();
hubContext.Clients.All.setCommentSupportOppose(dr);
}
return(JsonConvert.SerializeObject(dr));
}
public string GetFollowings(string UserID)
{
string UID = "";
try
{
UID = Convert.ToInt32(UserID).ToString();
}
catch
{
CFSession CFSess = (CFSession)Session["CFSess"];
UID = CFSess.ID;
}
return(JsonConvert.SerializeObject(BALUser.GetFollowers("", UID)));
}
public string GetPostsIFollow(string ID, string UserID)
{
//System.Threading.Thread.Sleep(1000);
string UID = "";
CFSession CFSess = (CFSession)Session["CFSess"];
try
{
UID = Convert.ToInt32(UserID).ToString();
}
catch
{
UID = CFSess.ID;
}
return(JsonConvert.SerializeObject(BALPost.GetPostsIFollow(CFSess.ID, ID, UID)));
}
public string GetUserProfileDetails(string UserID)
{
//System.Threading.Thread.Sleep(2000);
string UID = "";
CFSession CFSess = (CFSession)Session["CFSess"];
try
{
UID = Convert.ToInt32(UserID).ToString();
}
catch
{
UID = CFSess.ID;
}
return(JsonConvert.SerializeObject(BALUser.GetUserDetailsForProfile(CFSess.ID, UID)));
}
public string CreateTeam(string TeamName, string Description, int IssueID, string ImgUrl)
{
//if (
// (TeamName != "" & TeamName != null) &
// (Description != "" & Description != null) &
// (IssueID != 0) &
// (ImgUrl != "" & ImgUrl != null)
// )
DataTable dtTeamName = BAL.GetIssueTitle(IssueID);
if (dtTeamName.Rows.Count > 0)
{
if (FCommon.CheckEmptyStrings(TeamName, Description, ImgUrl) && FCommon.CheckEmptyInt(IssueID))
{
CFSession CFSess = (CFSession)Session["CFSess"];
BAL.TeamID = 0;
BAL.TeamName = dtTeamName.Rows[0]["Title"].ToString();
BAL.Description = Description;
BAL.CreatedBy = Convert.ToInt32(CFSess.ID);
BAL.CreatedDate = DateTime.Now;
BAL.ImgUrl = ImgUrl;
BAL.IssueID = IssueID;
BAL.StatusID = 1;
BAL.IsActive = true;
DataRow dr = BAL.InsertTeams(BAL);
BAL.InsertTeamMember(Convert.ToInt32(dr["TeamID"]), Convert.ToInt32(CFSess.ID), 1, DateTime.Now);
return(JsonConvert.SerializeObject(dr));
}
else
{
return(JsonConvert.SerializeObject(FCommon.ConvertReturn("Wrong")));
}
}
else
{
return(JsonConvert.SerializeObject(FCommon.ConvertReturn("Wrong")));
}
}
public ActionResult DLogin(string id)
{
if (id != "")
{
string dQuery = HttpUtility.UrlDecode(FCommon.Decrypt(id));
string[] dQueryArr = dQuery.Split('~');
DataRow dr = BALUser.LoginAuthentication(dQueryArr[0].ToString(), dQueryArr[1].ToString());
if (dr["ID"].ToString().Equals("0"))
{
}
else
{
if (dr["IsActive"].ToString().Equals("True"))
{
CFSession Sess = new CFSession();
Sess.ID = dr["ID"].ToString();
Sess.FirstName = dr["FirstName"].ToString();
Sess.LastName = dr["LastName"].ToString();
Sess.ImageUrl = dr["ImageUrl"].ToString();
Sess.fk_UserTypeID = Convert.ToInt32(dr["fk_UserTypeID"]);
Sess.IsFirstLogin = Convert.ToBoolean(dr["IsFirstLogin"]);
Session["CFSess"] = Sess;
//Response.Redirect("/Home/Index");
return(RedirectToAction("Index", "Home"));
}
else
{
}
}
return(View());
}
return(View());
}
public string Follow(string UserID)
{
CFSession CFSess = (CFSession)Session["CFSess"];
return(JsonConvert.SerializeObject(BALUser.InsertDeleteFollowers(CFSess.ID, UserID)));
}
public string GetTeamDiscussion(string ID)
{
CFSession CFSess = (CFSession)Session["CFSess"];
return(JsonConvert.SerializeObject(BAL.GetTeamComment(Convert.ToInt32(ID))));
}
public string GetMyTeams()
{
CFSession CFSess = (CFSession)Session["CFSess"];
return(JsonConvert.SerializeObject(BAL.GetTeams(0, Convert.ToInt32(CFSess.ID))));
}
public string GetTeamDetails(string id)
{
CFSession CFSess = (CFSession)Session["CFSess"];
return(JsonConvert.SerializeObject(BAL.GetTeams(Convert.ToInt32(id), Convert.ToInt32(CFSess.ID))));
}
public string InsertInterestedCategories(string Categories)
{
CFSession CFSess = (CFSession)Session["CFSess"];
return(JsonConvert.SerializeObject(BALUser.InsertUserInterestedCategories(CFSess.ID, Categories)));
}
public string GetHeaderDetails()
{
CFSession CFSess = (CFSession)Session["CFSess"];
return(JsonConvert.SerializeObject(CFSess));
}
