public JsonResult Eventdata(string EventId)
{
try
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
using (SqlCommand eventview = new SqlCommand("USPEventView", dbHandle.con))
{
eventview.CommandType = CommandType.StoredProcedure;
dbHandle.con.Open();
Session["eventId"] = EventId;
dbHandle.con.Close();
return(Json(new { id = 1 }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
ViewBag.error = "Error!!";
ExceptionLog.Log(e, Request.UserHostAddress);
return(Json(new { id = 404 }, JsonRequestBehavior.AllowGet));
}
finally
{
Dispose();
}
}
public JsonResult EventProfile()
{
try
{
if (Session["companyid"] != null)
{
DbConnection dbHandle = new DbConnection();
DataTable eventProfiledataTable = new DataTable();
dbHandle.Connection();
using (SqlCommand eventprofile = new SqlCommand("USPSingleEventView", dbHandle.con))
{
eventprofile.CommandType = CommandType.StoredProcedure;
eventprofile.Parameters.AddWithValue("@CompanyId", Session["companyid"]);
eventprofile.Parameters.AddWithValue("@EventId", Session["eventId"]);
dbHandle.con.Open();
SqlDataReader reader = eventprofile.ExecuteReader();
eventProfiledataTable.Load(reader);
dbHandle.con.Close();
return(Json(JsonConvert.SerializeObject(eventProfiledataTable), JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception e)
{
ViewBag.error = "Error!!";
ExceptionLog.Log(e, Request.UserHostAddress);
}
finally
{
Dispose();
}
return(Json(JsonRequestBehavior.AllowGet));
}
public JsonResult FetchGroupMessage(int groupId, int cId, int userId)
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
DataTable dataTable = new DataTable();
try
{
using (SqlCommand groupChatcmd = new SqlCommand("USPSelectGroupChatMessage", dbHandle.con))
{
groupChatcmd.CommandType = CommandType.StoredProcedure;
groupChatcmd.Parameters.AddWithValue("@userid", SqlDbType.Int).Value = userId;
groupChatcmd.Parameters.AddWithValue("@groupid", SqlDbType.Int).Value = groupId;
groupChatcmd.Parameters.AddWithValue("@companyid", SqlDbType.Int).Value = cId;
dbHandle.con.Open();
using (SqlDataReader reader = groupChatcmd.ExecuteReader())
{
dataTable.Load(reader);
}
}
return(Json(JsonConvert.SerializeObject(dataTable), JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
ExceptionLog.Log(e, Request.UserHostAddress);
return(Json(JsonRequestBehavior.AllowGet));
}
finally
{
dbHandle.con.Close();
Dispose();
}
}
public JsonResult BlockOrUnblockCompany(string CompanyId, string blockOperation)
{
try
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
using (SqlCommand blockorunblock = new SqlCommand("USPApproveOrDisApproveCompany", dbHandle.con))
{
blockorunblock.Connection = dbHandle.con;
dbHandle.con.Open();
blockorunblock.CommandType = CommandType.StoredProcedure;
blockorunblock.Parameters.Add("@CompanyId", SqlDbType.Int).Value = Convert.ToInt32(CompanyId);
blockorunblock.Parameters.Add("@Operation", SqlDbType.Int).Value = Convert.ToInt32(blockOperation);
blockorunblock.ExecuteNonQuery();
dbHandle.con.Close();
return(Json(new { id = 1 }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
ExceptionLog.Log(ex, Request.UserHostAddress);
return(Json(new { id = ex }, JsonRequestBehavior.AllowGet));
}
finally
{
Dispose();
}
}
public JsonResult FetchUserList(int uId, int cId)
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
DataTable dataTable = new DataTable();
try
{
using (SqlCommand listEmpcmd = new SqlCommand("USPEmployeeList", dbHandle.con))
{
listEmpcmd.CommandType = CommandType.StoredProcedure;
listEmpcmd.Parameters.AddWithValue("@CompanyId", SqlDbType.Int).Value = cId;
listEmpcmd.Parameters.AddWithValue("@UserId", SqlDbType.Int).Value = uId;
dbHandle.con.Open();
using (SqlDataReader reader = listEmpcmd.ExecuteReader())
{
dataTable.Load(reader);
}
}
return(Json(JsonConvert.SerializeObject(dataTable), JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
ExceptionLog.Log(e, Request.UserHostAddress);
return(Json(JsonRequestBehavior.AllowGet));
}
finally
{
dbHandle.con.Close();
Dispose();
}
}
public JsonResult MessageRead(int tId, int cId, int fId)
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
int flag = 0;
try
{
using (SqlCommand msgReadcmd = new SqlCommand("USPMessageRead", dbHandle.con))
{
msgReadcmd.CommandType = CommandType.StoredProcedure;
msgReadcmd.Parameters.AddWithValue("@FromId", SqlDbType.Int).Value = fId;
msgReadcmd.Parameters.AddWithValue("@ToId", SqlDbType.Int).Value = tId;
dbHandle.con.Open();
SqlDataAdapter da = new SqlDataAdapter(msgReadcmd);
DataSet ds = new DataSet();
da.Fill(ds);
}
return(Json(new { id = flag }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
ExceptionLog.Log(e, Request.UserHostAddress);
return(Json(JsonRequestBehavior.AllowGet));
}
finally
{
dbHandle.con.Close();
Dispose();
}
}
//Admin Delete Group
public JsonResult DeleteGroups()
{
try
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
using (SqlCommand deletegroup = new SqlCommand("USPDeleteGroup", dbHandle.con))
{
deletegroup.Connection = dbHandle.con;
dbHandle.con.Open();
deletegroup.CommandType = CommandType.StoredProcedure;
SqlParameter parm = new SqlParameter("@userId", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
deletegroup.Parameters.Add(parm);
deletegroup.Parameters.Add("@GroupId", SqlDbType.Int).Value = Session["groupId"];
deletegroup.Parameters.Add("@CompanyId", SqlDbType.Int).Value = Session["companyid"];
SqlDataAdapter da = new SqlDataAdapter(deletegroup);
DataSet ds = new DataSet();
da.Fill(ds);
int flag = Convert.ToInt32(parm.Value);
dbHandle.con.Close();
return(Json(new { id = 1 }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
ExceptionLog.Log(e, Request.UserHostAddress);
return(Json(new { id = 0 }, JsonRequestBehavior.AllowGet));
}
finally
{
Dispose();
}
}
public JsonResult PostData(string id, string notId)
{
try
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
using (SqlCommand groupsession = new SqlCommand("USPPostSession", dbHandle.con))
{
groupsession.CommandType = CommandType.StoredProcedure;
dbHandle.con.Open();
Session["postIdView"] = id;
Session["postReadId"] = notId;
dbHandle.con.Close();
return(Json(new { id = 1 }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
ViewBag.error = "Error!!";
ExceptionLog.Log(e, Request.UserHostAddress);
return(Json(new { id = 404 }, JsonRequestBehavior.AllowGet));
}
finally
{
Dispose();
}
}
//Remove Group members
public JsonResult RemoveGrpMember(string userTockenId)
{
try
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
using (SqlCommand removemember = new SqlCommand("USPRemoveGroupMember", dbHandle.con))
{
removemember.Connection = dbHandle.con;
dbHandle.con.Open();
removemember.CommandType = CommandType.StoredProcedure;
SqlParameter parm = new SqlParameter("@userId", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
removemember.Parameters.Add(parm);
removemember.Parameters.Add("@FK_GroupId", SqlDbType.Int).Value = Session["groupId"];; //Session["userid"];
removemember.Parameters.Add("@UserId", SqlDbType.VarChar).Value = userTockenId;
SqlDataAdapter da = new SqlDataAdapter(removemember);
DataSet ds = new DataSet();
da.Fill(ds);
int flag = Convert.ToInt32(parm.Value);
dbHandle.con.Close();
return(Json(new { id = 1 }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
ExceptionLog.Log(e, Request.UserHostAddress);
return(Json(new { id = 0 }, JsonRequestBehavior.AllowGet));
}
finally
{
Dispose();
}
}
//Group Name Validation
public JsonResult GroupValidation(string groupName)
{
try
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
using (SqlCommand grpvalidation = new SqlCommand("USPCheckGroupName", dbHandle.con))
{
grpvalidation.Connection = dbHandle.con;
dbHandle.con.Open();
grpvalidation.CommandType = CommandType.StoredProcedure;
SqlParameter parm = new SqlParameter("@flag", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
grpvalidation.Parameters.Add(parm);
grpvalidation.Parameters.AddWithValue("@GroupName", SqlDbType.Int).Value = groupName;
SqlDataAdapter da = new SqlDataAdapter(grpvalidation);
DataSet ds = new DataSet();
da.Fill(ds);
int flag = Convert.ToInt32(parm.Value);
dbHandle.con.Close();
return(Json(new { id = flag }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
ExceptionLog.Log(e, Request.UserHostAddress);
return(Json(new { id = 0 }, JsonRequestBehavior.AllowGet));
}
finally
{
Dispose();
}
}
//Search Group Member Name
public JsonResult SearchWithNameGroupMember(string procedureName)
{
try
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
DataTable dataTable = new DataTable();
using (SqlCommand searchbygrpmember = new SqlCommand(procedureName, dbHandle.con))
{
searchbygrpmember.Connection = dbHandle.con;
dbHandle.con.Open();
searchbygrpmember.CommandType = CommandType.StoredProcedure;
searchbygrpmember.Parameters.Add("@UserId", SqlDbType.Int).Value = Session["userid"];
searchbygrpmember.Parameters.Add("@GroupId", SqlDbType.Int).Value = Session["groupId"];
SqlDataReader reader = searchbygrpmember.ExecuteReader();
dataTable.Load(reader);
dbHandle.con.Close();
}
return(Json(JsonConvert.SerializeObject(dataTable), JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
ExceptionLog.Log(e, Request.UserHostAddress);
return(Json(new { }, JsonRequestBehavior.AllowGet));
}
finally
{
Dispose();
}
}
//Otp Validation
public JsonResult OtpValidation(string otp)
{
try
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
using (SqlCommand CheckOtp = new SqlCommand("USPOtpVerification", dbHandle.con))
{
CheckOtp.Connection = dbHandle.con;
dbHandle.con.Open();
CheckOtp.CommandType = CommandType.StoredProcedure;
SqlParameter parm = new SqlParameter("@flag", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
CheckOtp.Parameters.Add(parm);
CheckOtp.Parameters.AddWithValue("@otpNumber", SqlDbType.VarChar).Value = otp;
SqlDataAdapter da = new SqlDataAdapter(CheckOtp);
DataSet ds = new DataSet();
da.Fill(ds);
int flag = Convert.ToInt32(parm.Value);
Session["companyid"] = flag;
Session["otp"] = otp;
dbHandle.con.Close();
return(Json(new { id = flag }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
ExceptionLog.Log(e, Request.UserHostAddress);
return(Json(new { id = 0 }, JsonRequestBehavior.AllowGet));
}
finally
{
Dispose();
}
}
//DropDown List State
private static List <SelectListItem> drpList(string procedureName, string text, string value)
{
List <SelectListItem> items = new List <SelectListItem>();
try
{
SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConNew"].ConnectionString);
using (SqlCommand cmd = new SqlCommand(procedureName, con))
{
con.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
items.Add(new SelectListItem
{
Text = sdr[text].ToString(),
Value = sdr[value].ToString()
});
}
}
}
con.Close();
return(items);
}
catch (Exception ex)
{
ExceptionLog.Log(ex, "");
return(items);
}
finally
{
}
}
//Validate Email Id Is Already Exists
public JsonResult MailCheck(string mailidId)
{
try
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
using (SqlCommand checkMail = new SqlCommand("USPCheckMail", dbHandle.con))
{
checkMail.Connection = dbHandle.con;
dbHandle.con.Open();
checkMail.CommandType = CommandType.StoredProcedure;
SqlParameter parm = new SqlParameter("@flag", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
checkMail.Parameters.Add(parm);
checkMail.Parameters.AddWithValue("@email", SqlDbType.VarChar).Value = mailidId;
SqlDataAdapter da = new SqlDataAdapter(checkMail);
DataSet ds = new DataSet();
da.Fill(ds);
int flag = Convert.ToInt32(parm.Value);
dbHandle.con.Close();
return(Json(new { id = flag }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
ExceptionLog.Log(e, Request.UserHostAddress);
return(Json(new { id = 404 }, JsonRequestBehavior.AllowGet));
}
finally
{
Dispose();
}
}
public JsonResult GroupMemberDisplay()
{
try
{
DataTable dataTable = new DataTable();
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
using (SqlCommand grpMemberDisplay = new SqlCommand("USPGroupMemberDisplay", dbHandle.con))
{
grpMemberDisplay.CommandType = CommandType.StoredProcedure;
grpMemberDisplay.Parameters.Add("@GroupId", SqlDbType.Int).Value = Session["groupId"];
dbHandle.con.Open();
SqlDataReader reader = grpMemberDisplay.ExecuteReader();
dataTable.Load(reader);
dbHandle.con.Close();
return(Json(JsonConvert.SerializeObject(dataTable), JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
ViewBag.error = "Error!!";
ExceptionLog.Log(e, Request.UserHostAddress);
}
finally
{
Dispose();
}
return(Json(JsonRequestBehavior.AllowGet));
}
public JsonResult NotificationCall()
{
try
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
using (SqlCommand Notificationcommand = new SqlCommand("[dbo].[USPNotificationSelect]", dbHandle.con))
{
dbHandle.con.Open();
Notificationcommand.Notification = null;
Notificationcommand.CommandType = CommandType.StoredProcedure;
Notificationcommand.Parameters.Add("@NotificationToId", SqlDbType.Int).Value = Session["userid"];
Notificationcommand.ExecuteNonQuery();
SqlDependency dependency = new SqlDependency(Notificationcommand);
dependency.OnChange += new OnChangeEventHandler(dependency_OnChange);
SqlDataReader reader = Notificationcommand.ExecuteReader();
}
dbHandle.con.Close();
return(Json(JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ViewBag.error = "Error!!";
ExceptionLog.Log(ex, Request.UserHostAddress);
}
finally
{
Dispose();
}
return(Json(JsonRequestBehavior.AllowGet));
}
public JsonResult GroupDisplay()
{
try
{
DbConnection dbHandle = new DbConnection();
DataTable GroupDisplydataTable = new DataTable();
dbHandle.Connection();
using (SqlCommand groupdisplay = new SqlCommand("USPGroupView", dbHandle.con))
{
groupdisplay.CommandType = CommandType.StoredProcedure;
groupdisplay.Parameters.AddWithValue("@UserId", Session["userid"]);
dbHandle.con.Open();
SqlDataReader reader = groupdisplay.ExecuteReader();
GroupDisplydataTable.Load(reader);
dbHandle.con.Close();
return(Json(JsonConvert.SerializeObject(GroupDisplydataTable), JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
ViewBag.error = "Error!!";
ExceptionLog.Log(e, Request.UserHostAddress);
return(Json(new { id = 404 }, JsonRequestBehavior.AllowGet));
}
finally
{
Dispose();
}
}
public JsonResult InsertComment(string CommentText, string PostId)
{
try
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
using (SqlCommand groupcommentpost = new SqlCommand("USPGroupCommentPosting", dbHandle.con))
{
groupcommentpost.CommandType = CommandType.StoredProcedure;
groupcommentpost.Parameters.Add("GroupPostId", SqlDbType.Int).Value = Convert.ToInt32(PostId);
groupcommentpost.Parameters.Add("@Comment", SqlDbType.VarChar).Value = CommentText;
groupcommentpost.Parameters.Add("@CommentedUserId", SqlDbType.Int).Value = Session["userid"];
groupcommentpost.Parameters.Add("@CompanyId", SqlDbType.Int).Value = Session["companyid"];
groupcommentpost.Parameters.Add("@GroupId", SqlDbType.Int).Value = Session["groupId"];
dbHandle.con.Open();
groupcommentpost.ExecuteNonQuery();
dbHandle.con.Close();
return(Json(new { id = 1 }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
ViewBag.error = "Error!!";
ExceptionLog.Log(e, Request.UserHostAddress);
return(Json(new { id = 404 }, JsonRequestBehavior.AllowGet));
}
finally
{
Dispose();
}
}
//Remove Employee
public JsonResult RemoveEmployeeById(int userId)
{
try
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
using (SqlCommand removeempolyees = new SqlCommand("USPRemoveEmployee", dbHandle.con))
{
removeempolyees.CommandType = CommandType.StoredProcedure;
removeempolyees.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
dbHandle.con.Open();
removeempolyees.ExecuteNonQuery();
dbHandle.con.Close();
return(Json(new { id = 1 }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
ViewBag.error = "Error!!";
ExceptionLog.Log(e, Request.UserHostAddress);
return(Json(new { id = 404 }, JsonRequestBehavior.AllowGet));
}
finally
{
Dispose();
}
}
public JsonResult Insertdislike(string PostId)
{
try
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
using (SqlCommand groupdislike = new SqlCommand("USPGroupLike", dbHandle.con))
{
groupdislike.CommandType = CommandType.StoredProcedure;
groupdislike.Parameters.Add("@FK_GroupId", SqlDbType.Int).Value = Session["groupId"];
groupdislike.Parameters.Add("@FK_PostId", SqlDbType.Int).Value = Convert.ToInt32(PostId);
groupdislike.Parameters.Add("@FK_UserId", SqlDbType.Int).Value = Session["userid"];
groupdislike.Parameters.Add("@CompanyId", SqlDbType.Int).Value = Session["companyid"];
groupdislike.Parameters.Add("@Operation", SqlDbType.Int).Value = 2;
dbHandle.con.Open();
groupdislike.ExecuteNonQuery();
dbHandle.con.Close();
return(Json(new { id = 1 }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
ViewBag.error = "Error!!";
ExceptionLog.Log(e, Request.UserHostAddress);
return(Json(new { id = 404 }, JsonRequestBehavior.AllowGet));
}
finally
{
Dispose();
}
}
public JsonResult GroupDetails()
{
try
{
DataTable dataTable = new DataTable();
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
using (SqlCommand singlegroupview = new SqlCommand("USPSingleGroup", dbHandle.con))
{
singlegroupview.CommandType = CommandType.StoredProcedure;
singlegroupview.Parameters.AddWithValue("@GroupId", Session["groupId"]);
dbHandle.con.Open();
SqlDataReader reader = singlegroupview.ExecuteReader();
dataTable.Load(reader);
dbHandle.con.Close();
return(Json(JsonConvert.SerializeObject(dataTable), JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
ViewBag.error = "Error!!";
ExceptionLog.Log(e, Request.UserHostAddress);
return(Json(new { id = 404 }, JsonRequestBehavior.AllowGet));
}
finally
{
Dispose();
}
}
public JsonResult DeleteUserComment(string CommentId)
{
try
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
using (SqlCommand deletePost = new SqlCommand("USPDeleteComment", dbHandle.con))
{
deletePost.CommandType = CommandType.StoredProcedure;
deletePost.Parameters.Add("@CommentId", SqlDbType.Int).Value = Convert.ToInt32(CommentId);
deletePost.Parameters.Add("@UserId", SqlDbType.Int).Value = Session["userid"];
dbHandle.con.Open();
deletePost.ExecuteNonQuery();
dbHandle.con.Close();
return(Json(JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
ViewBag.error = "Error!!";
ExceptionLog.Log(e, Request.UserHostAddress);
return(Json(JsonRequestBehavior.AllowGet));
}
finally
{
Dispose();
}
}
public JsonResult ShowProfileReplay(string commentid)
{
try
{
DbConnection dbHandle = new DbConnection();
DataTable dataTable = new DataTable();
dbHandle.Connection();
using (SqlCommand userpostcomment = new SqlCommand("UspShowGroupReplay", dbHandle.con))
{
userpostcomment.CommandType = CommandType.StoredProcedure;
userpostcomment.Parameters.Add("@CommentId", SqlDbType.Int).Value = commentid;
userpostcomment.Parameters.AddWithValue("@userid", Session["userid"]);
dbHandle.con.Open();
SqlDataReader reader = userpostcomment.ExecuteReader();
dataTable.Load(reader);
dbHandle.con.Close();
return(Json(JsonConvert.SerializeObject(dataTable), JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
ViewBag.error = "Error!!";
ExceptionLog.Log(e, Request.UserHostAddress);
return(Json(new { id = 404 }, JsonRequestBehavior.AllowGet));
}
finally
{
Dispose();
}
}
public JsonResult ProfileDetails()
{
try
{
DbConnection dbHandle = new DbConnection();
DataTable dataTable = new DataTable();
dbHandle.Connection();
using (SqlCommand profiledetails = new SqlCommand("USPProfilePost", dbHandle.con))
{
profiledetails.CommandType = CommandType.StoredProcedure;
profiledetails.Parameters.AddWithValue("@UserId", Session["userid"]);
profiledetails.Parameters.AddWithValue("@CompanyId", Session["companyid"]);
dbHandle.con.Open();
SqlDataReader reader = profiledetails.ExecuteReader();
dataTable.Load(reader);
dbHandle.con.Close();
return(Json(JsonConvert.SerializeObject(dataTable), JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
ViewBag.error = "Error!!";
ExceptionLog.Log(e, Request.UserHostAddress);
}
finally
{
Dispose();
}
return(Json(JsonRequestBehavior.AllowGet));
}
public JsonResult InsertPost()
{
string Imagepath = "";
try
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
string PostMessages = System.Web.HttpContext.Current.Request.Form["postmessage"];
if (Request.Files.Count > 0)
{
for (int i = 0; i < Request.Files.Count; i++)
{
HttpPostedFileBase filebase = Request.Files[i];
string randomNo = System.DateTime.Now.ToString("ddMMyyhhmmss");
string fileName = randomNo + Path.GetFileName(filebase.FileName);
Imagepath = Imagepath + "../Images/" + fileName + ',';
filebase.SaveAs(Server.MapPath("../Images/") + fileName);
}
}
using (SqlCommand createpost = new SqlCommand("USPInsertPost", dbHandle.con))
{
createpost.CommandType = CommandType.StoredProcedure;
SqlParameter parm = new SqlParameter("@PostId", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
createpost.Parameters.Add(parm);
createpost.Parameters.Add("@PostMessage", SqlDbType.VarChar).Value = PostMessages;
createpost.Parameters.Add("@FK_UserId", SqlDbType.Int).Value = Session["userid"];
createpost.Parameters.Add("@PostUrl", SqlDbType.VarChar).Value = Imagepath;
if (Imagepath == "")
{
createpost.Parameters.Add("@FK_PostTypeId", SqlDbType.Int).Value = 3;
}
else
{
createpost.Parameters.Add("@FK_PostTypeId", SqlDbType.Int).Value = 1;
}
createpost.Parameters.Add("@CompanyId", SqlDbType.Int).Value = Session["companyid"];
dbHandle.con.Open();
createpost.ExecuteNonQuery();
int flag = Convert.ToInt32(parm.Value);
Session["postid"] = flag;
dbHandle.con.Close();
return(Json(new { id = 1 }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
ViewBag.error = "Error!!";
ExceptionLog.Log(e, Request.UserHostAddress);
return(Json(new { id = 404 }, JsonRequestBehavior.AllowGet));
}
finally
{
Dispose();
}
}
public JsonResult ShowComment(string showPost)
{
try
{
DbConnection dbHandle = new DbConnection();
DataTable showCommentdataTable = new DataTable();
dbHandle.Connection();
using (SqlCommand viewcmt = new SqlCommand("USPShowComment", dbHandle.con))
{
viewcmt.CommandType = CommandType.StoredProcedure;
viewcmt.Parameters.Add("@PostId", SqlDbType.Int).Value = Convert.ToInt32(showPost);
dbHandle.con.Open();
SqlDataReader reader = viewcmt.ExecuteReader();
showCommentdataTable.Load(reader);
dbHandle.con.Close();
return(Json(JsonConvert.SerializeObject(showCommentdataTable), JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
ViewBag.error = "Error!!";
ExceptionLog.Log(e, Request.UserHostAddress);
return(Json(new { id = 404 }, JsonRequestBehavior.AllowGet));
}
finally
{
Dispose();
}
}
public JsonResult InsertReplay(string CommentId, string CommentText)
{
try
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
using (SqlCommand commentpost = new SqlCommand("USPReplies", dbHandle.con))
{
dbHandle.con.Open();
commentpost.CommandType = CommandType.StoredProcedure;
commentpost.Parameters.Add("@CommentedId", SqlDbType.Int).Value = Convert.ToInt32(CommentId);
commentpost.Parameters.Add("@Replay", SqlDbType.VarChar).Value = CommentText;
commentpost.Parameters.Add("@UserId", SqlDbType.Int).Value = Session["userid"];
commentpost.Parameters.Add("@CompanyCode", SqlDbType.Int).Value = Session["companyid"];
commentpost.ExecuteNonQuery();
dbHandle.con.Close();
return(Json(new { id = 1 }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
ViewBag.error = "Error!!";
ExceptionLog.Log(e, Request.UserHostAddress);
return(Json(new { id = 404 }, JsonRequestBehavior.AllowGet));
}
finally
{
Dispose();
}
}
public ActionResult UserProfile(Register Register)
{
try
{
if (Session["userid"] != null)
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
using (SqlCommand RegCmd = new SqlCommand("USPProfileView", dbHandle.con))
{
RegCmd.Connection = dbHandle.con;
RegCmd.CommandType = CommandType.StoredProcedure;
if (Session["useridSearch"] != null)
{
RegCmd.Parameters.AddWithValue("@UserId", Session["useridSearch"]);
Session["useridSearch"] = null;
}
else if (Session["userid"] != null)
{
RegCmd.Parameters.AddWithValue("@UserId", Session["userid"]);
}
dbHandle.con.Open();
using (SqlDataReader profile = RegCmd.ExecuteReader())
{
while (profile.Read())
{
RegCmd.Connection = dbHandle.con;
Register.name = profile["Name"].ToString();
DateTime dob = Convert.ToDateTime(profile["DateofBirth"]);
Register.dateOfBirth = (dob.Date).ToShortDateString();
Register.age = Convert.ToInt32(profile["Age"]);
Register.nationality = profile["Nationality"].ToString();
Register.address = profile["Address"].ToString();
Register.mobile = profile["Mobile"].ToString();
Register.email = profile["Email"].ToString();
Register.gender = profile["Gender"].ToString();
Register.companyName = profile["CompanyName"].ToString();
Register.UserPhoto = profile["ImageUrl"].ToString();
}
}
}
}
else
{
return(RedirectToAction("LoginUser", "UserLogin"));
}
}
catch (Exception e)
{
ExceptionLog.Log(e, Request.UserHostAddress);
}
finally
{
Dispose();
}
return(View(Register));
}
public ActionResult UserRegister(Register Register)
{
try
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
using (SqlCommand UserRegistercmd = new SqlCommand("USPUserRegistration", dbHandle.con))
{
if (Session["otp"] != null)
{
Register.UserTypeID = 1;
}
DateTime dob = Convert.ToDateTime(Register.dateOfBirth);
string Random = System.DateTime.Now.ToString("ddMMyyhhmmss");
Register.UserPhoto = "../Images/" + Random + Register.userImg.FileName;
Register.userImg.SaveAs(Server.MapPath("../Images/") + Random + Register.userImg.FileName);
UserRegistercmd.CommandType = CommandType.StoredProcedure;
UserRegistercmd.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = Register.firstName;
UserRegistercmd.Parameters.Add("@SecondName", SqlDbType.VarChar).Value = Register.secondName;
UserRegistercmd.Parameters.Add("@Dob", SqlDbType.Date).Value = dob;
UserRegistercmd.Parameters.Add("Age", SqlDbType.Int).Value = DateTime.Today.Year - dob.Year;
UserRegistercmd.Parameters.Add("@Gender", SqlDbType.Int).Value = int.Parse(Register.gender);
UserRegistercmd.Parameters.AddWithValue("@DesignationId", SqlDbType.Int).Value = Register.DesignationId;
UserRegistercmd.Parameters.Add("@CompanyCode", SqlDbType.VarChar).Value = Session["companyid"];
UserRegistercmd.Parameters.Add("@Address", SqlDbType.VarChar).Value = Register.address;
UserRegistercmd.Parameters.Add("@Nationality", SqlDbType.VarChar).Value = Register.nationality;
UserRegistercmd.Parameters.Add("@Mobile", SqlDbType.VarChar).Value = Register.mobile;
UserRegistercmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = Register.email;
UserRegistercmd.Parameters.Add("@UserType", SqlDbType.Int).Value = Register.UserTypeID;
UserRegistercmd.Parameters.Add("@UserName", SqlDbType.VarChar).Value = Register.username;
UserRegistercmd.Parameters.Add("@Password", SqlDbType.VarChar).Value = Crypto.Encryption(Register.password);
UserRegistercmd.Parameters.Add("@ImageUrl", SqlDbType.VarChar).Value = Register.UserPhoto;
UserRegistercmd.Parameters.Add("@UserStatus", SqlDbType.Int).Value = 0;
dbHandle.con.Open();
UserRegistercmd.ExecuteNonQuery();
Session["otp"] = null;
dbHandle.con.Close();
ViewBag.error = "Company Registration Sucess";
Mail.SendMail(Register.email, "Your User Name and Password ", "User Name :" + Register.username + "Paassword :" + Register.password);
}
}
catch (Exception e)
{
ViewBag.error = "Error!!";
ExceptionLog.Log(e, Request.UserHostAddress);
return(RedirectToAction("Error_View", "CompanyRegister"));
}
finally
{
Dispose();
}
return(RedirectToAction("LoginUser", "UserLogin"));
}
public IEnumerable <Messages> GetAllMessages()
{
List <Messages> messages = new List <Messages>();
try
{
DbConnection dbHandle = new DbConnection();
dbHandle.Connection();
using (SqlCommand Notificationcommand = new SqlCommand("[dbo].[USPNotificationSelect]", dbHandle.con))
{
dbHandle.con.Open();
Notificationcommand.Notification = null;
Notificationcommand.CommandType = CommandType.StoredProcedure;
Notificationcommand.Parameters.Add("@NotificationToId", SqlDbType.Int).Value = Session["userid"];
Notificationcommand.ExecuteNonQuery();
SqlDependency dependency = new SqlDependency(Notificationcommand);
dependency.OnChange += new OnChangeEventHandler(dependency_OnChange);
if (dbHandle.con.State == ConnectionState.Closed)
{
dbHandle.con.Open();
}
SqlDataReader reader = Notificationcommand.ExecuteReader();
while (reader.Read())
{
messages.Add(item:
new Messages
{
userId = (int)reader["NotificationToId"],
postId = (int)reader["PostId"],
viewedBy = (string)reader["NotificationBy"],
notificationType = (string)reader["NotificationType"],
notificationId = (int)reader["NotificationId"],
});
}
dbHandle.con.Close();
return(messages);
}
}
catch (Exception e)
{
ViewBag.error = "Error!!";
ExceptionLog.Log(e, Request.UserHostAddress);
}
finally
{
Dispose();
}
return(messages);
}
