public PartialViewResult get_list_msg() { App_Start.ConnectionString constr = new App_Start.ConnectionString(); ConnectionString = constr.GetConnectionString(); SqlConnection conn = new SqlConnection(ConnectionString); SqlDataReader rdr = null; //====================================== //-------------- Get Session --- #region Get Session User userinfo = new User(); if (Session["User"] != null) { userinfo = (User)Session["User"]; } else { userinfo = null; } #endregion //-------------- Get Session --- //====================================== //================================================= //--------- Get Unread Msg --- List <MessageListVM> UserMsgList = new List <MessageListVM>(); if (userinfo != null) { #region Get Unread Msg try { if (conn.State != ConnectionState.Open) { conn.Open(); } SqlCommand cmd = new SqlCommand(@"SP_MSGLIST_Inbox_UNREAD_USER", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Username", SqlDbType.Int)); cmd.Parameters["@Username"].Value = userinfo.username; rdr = cmd.ExecuteReader(); DataTable dataTable = new DataTable(); dataTable.Load(rdr); if (dataTable != null) { if (dataTable.Rows.Count > 0) { UserMsgList = (from DataRow dr in dataTable.Rows select new MessageListVM() { id = int.Parse(dr["id"].ToString()), username_sender = dr["username_sender"].ToString(), Title = dr["Title"].ToString(), Msg_Content = dr["Msg_Content"].ToString(), Date = dr["Date"].ToString() != "" ? DateTime.Parse(dr["Date"].ToString()) : (DateTime?)null, Type = dr["Type"].ToString() != "" ? byte.Parse(dr["Type"].ToString()) : (byte?)null, instituteid = int.Parse(dr["instituteid"].ToString()), status_Receiver = dr["status_Receiver"].ToString() != "" ? byte.Parse(dr["status_Receiver"].ToString()) : (byte?)null, Attach = dr["Attach"].ToString() != "" ? bool.Parse(dr["Attach"].ToString()) : (bool?)null, sender = dr["sender"].ToString(), name = dr["name"].ToString() } ).ToList(); dataTable.Dispose(); } } } catch (Exception ex) { if (rdr != null) { rdr.Close(); rdr = null; } if (conn.State == ConnectionState.Open) { conn.Dispose(); conn.Close(); } ViewBagError viewbagerror = new ViewBagError(); viewbagerror.ClassName = "alert-danger"; viewbagerror.Msg = "خطا در لود پیام ها : " + ex.Message; ViewBag.ErrorMsg = viewbagerror; } #endregion } //--------- Get Unread Notic --- //================================================= if (rdr != null) { rdr.Close(); rdr = null; } if (conn.State == ConnectionState.Open) { conn.Dispose(); conn.Close(); } return(PartialView("~/Views/Shared/Partial/ManagerDashboard/_UnreadMessage.cshtml", UserMsgList)); }
public PartialViewResult get_list_institute() { App_Start.ConnectionString constr = new App_Start.ConnectionString(); ConnectionString = constr.GetConnectionString(); SqlConnection conn = new SqlConnection(ConnectionString); SqlDataReader rdr = null; //====================================== //-------------- Get Session --- #region Get Session User userinfo = new User(); if (Session["User"] != null) { userinfo = (User)Session["User"]; } else { userinfo = null; } #endregion //-------------- Get Session --- //====================================== //============================================= //--- Get List User Institute From User_Jobs -- List <ViewModel.InstituteList_VM> instituteList = new List <InstituteList_VM>(); #region Get List User Institute From User_Jobs try { if (conn.State != ConnectionState.Open) { conn.Open(); } SqlCommand cmd = new SqlCommand(@"SP_USER_INSTITUTE", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Username", SqlDbType.Int)); cmd.Parameters["@Username"].Value = userinfo.username; rdr = cmd.ExecuteReader(); DataTable dataTable = new DataTable(); dataTable.Load(rdr); if (dataTable != null) { if (dataTable.Rows.Count > 0) { instituteList = (from DataRow dr in dataTable.Rows select new InstituteList_VM() { id = Int64.Parse(dr["id"].ToString()), name = dr["name"].ToString(), educationalType = dr["educationalType"].ToString() } ).ToList(); dataTable.Dispose(); } } } catch (Exception ex) { if (rdr != null) { rdr.Close(); rdr = null; } if (conn.State == ConnectionState.Open) { conn.Dispose(); conn.Close(); } ViewBagError viewbagerror = new ViewBagError(); viewbagerror.ClassName = "alert-danger"; viewbagerror.Msg = "خطا در لود لیست مدارس : " + ex.Message; ViewBag.ErrorMsg = viewbagerror; } #endregion //--- Get List User Institute From User_Jobs -- //============================================= if (rdr != null) { rdr.Close(); rdr = null; } if (conn.State == ConnectionState.Open) { conn.Dispose(); conn.Close(); } return(PartialView("~/Views/Shared/Partial/ManagerDashboard/_InstituteListSideMenu.cshtml", instituteList)); //return Json("access denied", JsonRequestBehavior.AllowGet); }