//------------------- Article List ----------------- //================================================== //================================================== //----------------- Update Download Article -------- public void ArticleDownload(int id) { //----------- update ------------ #region Update Article App_Start.ConnectionString constr = new App_Start.ConnectionString(); ConnectionString = constr.GetConnectionString(); // 1. Instantiate the connection SqlConnection conn = new SqlConnection(ConnectionString); SqlDataReader rdr = null; try { conn.Open(); SqlCommand cmd; cmd = new SqlCommand(@"SP_UPDATE_ARTICLE_DOWNLOAD", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@id", SqlDbType.Int)); cmd.Parameters["@id"].Value = id; cmd.ExecuteNonQuery(); } catch (Exception ex) { conn.Close(); conn.Dispose(); } #endregion Update Article //----------- update ------------ }
public ActionResult ArticleList(string search_text, int?page) { int Startindex = 0; int pagesize = 1; page = page.HasValue ? Convert.ToInt32(page) - 1 : 0; Startindex = page.HasValue ? Convert.ToInt32(page * pagesize) : 0; List <ViewModel.Article_User_Rank_VM> article_list = new List <ViewModel.Article_User_Rank_VM>(); int Total_item = 0; int Total_page = 0; int?Current_page = page; //=================================================================== //--------------------- Get Session User ---------------------------- #region Get Session User string username = null; if (Session["User"] != null) { User currentuser = (User)Session["User"]; username = currentuser.username; } #endregion Get Session User //--------------------- Get Session User ---------------------------- //=================================================================== //=================================================================== //---------------------- Get Article List --------------------------- #region Get Article List App_Start.ConnectionString constr = new App_Start.ConnectionString(); ConnectionString = constr.GetConnectionString(); // 1. Instantiate the connection SqlConnection conn = new SqlConnection(ConnectionString); SqlDataReader rdr = null; try { conn.Open(); SqlCommand cmd; if (username == null) { cmd = new SqlCommand(@"SP_ARTICLE_LIST", conn); } else { cmd = new SqlCommand(@"SP_ARTICLE_USER_LIST", conn); cmd.Parameters.Add(new SqlParameter("@Username", SqlDbType.NVarChar, 50)); cmd.Parameters["@Username"].Value = username; } cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@search", SqlDbType.NVarChar, 50)); cmd.Parameters["@search"].Value = "%" + search_text + "%"; cmd.Parameters.Add(new SqlParameter("@PageSize", SqlDbType.Int)); cmd.Parameters["@PageSize"].Value = pagesize; cmd.Parameters.Add(new SqlParameter("@CurrentPage", SqlDbType.Int)); cmd.Parameters["@CurrentPage"].Value = page; rdr = cmd.ExecuteReader(); DataTable dataTable = new DataTable(); dataTable.Load(rdr); if (dataTable != null) { if (dataTable.Rows.Count > 0) { article_list = (from DataRow dr in dataTable.Rows select new ViewModel.Article_User_Rank_VM() { id = Convert.ToInt32(dr["id"]), Title = dr["Title"].ToString(), En_Title = dr["En_Title"].ToString(), Description = dr["Description"].ToString(), writer = dr["writer"].ToString(), Download = dr["Download"].ToString() != "" ? int.Parse(dr["Download"].ToString()) : int.Parse("0"), Date = dr["Date"].ToString() != "" ? DateTime.Parse(dr["Date"].ToString()) :(DateTime?)null } ).ToList(); //===================================================== //---------------- Get Total item for pager ----------- rdr = null; cmd = new SqlCommand(@"SP_TOTAL_ARTICLE_LIST", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@search", SqlDbType.NVarChar, 50)); cmd.Parameters["@search"].Value = "%" + search_text + "%"; rdr = cmd.ExecuteReader(); dataTable = new DataTable(); dataTable.Load(rdr); if (dataTable != null) { if (dataTable.Rows.Count > 0) { DataRow dr = dataTable.Rows[0]; Total_item = dr["Total"].ToString() != "" ? int.Parse(dr["Total"].ToString()) : 0; } } //---------------- Get Total item for pager ----------- //===================================================== rdr = null; dataTable.Dispose(); conn.Close(); conn.Dispose(); } } } catch (Exception ex) { conn.Close(); conn.Dispose(); } #endregion Get Article List //---------------------- Get Article List --------------------------- //=================================================================== //institute_list = db.Institutes.Where(p => p.city_code.StartsWith(city)).Where(p => p.name.Contains(search_text)).OrderBy(p => p.name).Skip(Startindex).Take(pagesize).ToList(); //Total_item = db.Institutes.Where(p => p.city_code.StartsWith(city)).Where(p => p.name.Contains(search_text)).Select(p => p.id).Count(); Total_page = Total_item / pagesize; //========================================== //---------------- Set ViewBag ------------- ViewBag.Total_item = Total_item; ViewBag.Total_page = Total_page; ViewBag.Current_page = Current_page; //---------------- Set ViewBag ------------- //========================================== return(PartialView("~/Views/Shared/Partial/_ArticleList.cshtml", article_list)); }
public ActionResult institute(int id) { if (id != 0) { App_Start.ConnectionString constr = new App_Start.ConnectionString(); ConnectionString = constr.GetConnectionString(); SqlConnection conn = new SqlConnection(ConnectionString); SqlDataReader rdr = null; //============================================================ //--------------------- Get Institute Info ------ ViewModel.InstituteInfo_VM InstituteInfo = new ViewModel.InstituteInfo_VM(); #region Get Institute Info try { if (conn.State != ConnectionState.Open) { conn.Open(); } SqlCommand cmd = new SqlCommand(@"select Institutes.id,Institutes.name,Institutes.tel1,Institutes.tel2,Institutes.website,Institutes.address ,Institutes.boyOrGirl,Institutes.city_code,Institutes.shoar,Institutes.Email ,Institutes.Group_Channel1,Institutes.Group_Channel2,Institutes.Group_Channel3,Institutes.Group_Channel4 ,Institutes.Description,Institutes.mobile1,Institutes.mobile2,Institutes.Google_Map,Institutes.En_Name ,(select InstituteKind.Name from InstituteKind where InstituteKind.id=Institutes.InstituteKindid) as InstituteKindName from Institutes where Institutes.id =@id and (Institutes.Active is null or Institutes.Active=1) " , conn); cmd.Parameters.Add(new SqlParameter("@id", SqlDbType.BigInt)); cmd.Parameters["@id"].Value = id; rdr = cmd.ExecuteReader(); DataTable dataTable = new DataTable(); dataTable.Load(rdr); if (dataTable != null) { if (dataTable.Rows.Count > 0) { DataRow dr = dataTable.Rows[0]; InstituteInfo.id = id; InstituteInfo.name = dr["name"].ToString(); InstituteInfo.tel1 = dr["tel1"].ToString(); InstituteInfo.tel2 = dr["tel2"].ToString(); InstituteInfo.website = dr["website"].ToString(); InstituteInfo.address = dr["address"].ToString(); InstituteInfo.boyOrGirl = dr["boyOrGirl"].ToString() != ""?bool.Parse(dr["boyOrGirl"].ToString()):(bool?)null; InstituteInfo.city_code = dr["city_code"].ToString(); InstituteInfo.shoar = dr["shoar"].ToString(); InstituteInfo.Email = dr["Email"].ToString(); InstituteInfo.Group_Channel1 = dr["Group_Channel1"].ToString(); InstituteInfo.Group_Channel2 = dr["Group_Channel2"].ToString(); InstituteInfo.Group_Channel3 = dr["Group_Channel3"].ToString(); InstituteInfo.Group_Channel4 = dr["Group_Channel4"].ToString(); InstituteInfo.Description = dr["Description"].ToString(); InstituteInfo.mobile1 = dr["mobile1"].ToString(); InstituteInfo.mobile2 = dr["mobile2"].ToString(); InstituteInfo.Google_Map = dr["Google_Map"].ToString(); InstituteInfo.En_Name = dr["En_Name"].ToString(); InstituteInfo.InstituteKindName = dr["InstituteKindName"].ToString(); dataTable.Dispose(); } } } catch (Exception ex) { if (rdr != null) { rdr.Close(); rdr = null; } if (conn.State == ConnectionState.Open) { conn.Dispose(); conn.Close(); } ViewModel.ViewBagError viewbagerror = new ViewModel.ViewBagError(); viewbagerror.ClassName = "alert-danger"; viewbagerror.Msg = "خطا در لود اطلاعات آموزشگاه : " + ex.Message; ViewBag.ErrorMsg = viewbagerror; } #endregion //--------------------- Get Institute Info ------ //============================================================ if (InstituteInfo.name != null) { //============================================================ //--------------------- Get Institute Grades ------ List <Grade> InstituteGrades = new List <Grade>(); #region Get Institute Grades try { if (conn.State != ConnectionState.Open) { conn.Open(); } SqlCommand cmd = new SqlCommand(@"select Grades.id,Grades.Name from Institute_Grade inner join Grades ON Institute_Grade.Instituteid=@id AND Grades.id = Institute_Grade.Gradeid " , conn); cmd.Parameters.Add(new SqlParameter("@id", SqlDbType.BigInt)); cmd.Parameters["@id"].Value = id; rdr = cmd.ExecuteReader(); DataTable dataTable = new DataTable(); dataTable.Load(rdr); if (dataTable != null) { if (dataTable.Rows.Count > 0) { InstituteGrades = (from DataRow dr in dataTable.Rows select new Grade() { id = int.Parse(dr["id"].ToString()), Name = dr["Name"].ToString() } ).ToList(); ViewBag.InstituteGrades = InstituteGrades; dataTable.Dispose(); } } } catch (Exception ex) { if (rdr != null) { rdr.Close(); rdr = null; } if (conn.State == ConnectionState.Open) { conn.Dispose(); conn.Close(); } ViewModel.ViewBagError viewbagerror = new ViewModel.ViewBagError(); viewbagerror.ClassName = "alert-danger"; viewbagerror.Msg = "خطا در لود پایه های تحصیلی آموزشگاه : " + ex.Message; ViewBag.ErrorMsg = viewbagerror; } #endregion //--------------------- Get Institute Grades ------ //============================================================ try { ViewBag.Images = Directory.EnumerateFiles(Server.MapPath("~/Content/images/schools/" + id + "")) .Where(fn => Path.GetFileName(fn) != InstituteInfo.id + "-logo.png" && Path.GetFileName(fn) != InstituteInfo.id + "-main.png" && Path.GetFileName(fn) != InstituteInfo.id + "-head.png" ) .Select(fn => "~/Content/images/schools/" + id + "/" + Path.GetFileName(fn)); } catch (Exception ex) { ; } } if (rdr != null) { rdr.Close(); rdr = null; } if (conn.State == ConnectionState.Open) { conn.Dispose(); conn.Close(); } return(View(InstituteInfo)); } return(View()); }
public ActionResult Index() { App_Start.ConnectionString constr = new App_Start.ConnectionString(); ConnectionString = constr.GetConnectionString(); SqlConnection conn = new SqlConnection(ConnectionString); SqlDataReader rdr = null; //============================================================ //------------- Get Institute 4 Selected In Home --------- List <ViewModel.InstituteSmallVM> InstituteList = new List <ViewModel.InstituteSmallVM>(); #region Get Institute 4 Selected In Home try { if (conn.State != ConnectionState.Open) { conn.Open(); } string query = ""; query = @"select top 4 id,name,En_Name ,address,boyOrGirl,(select Name from InstituteKind where InstituteKind.id=Institutes.InstituteKindid ) as InstituteKindName from Institutes where (Active is null or Active =1 ) order by [order]" ; SqlCommand cmd = new SqlCommand(query, conn); 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 ViewModel.InstituteSmallVM() { id = Int64.Parse(dr["id"].ToString()), name = dr["name"].ToString(), En_Name = dr["En_Name"].ToString(), InstituteKindName = dr["InstituteKindName"].ToString(), address = dr["address"].ToString(), boyOrGirl = dr["boyOrGirl"].ToString() != "" ? bool.Parse(dr["boyOrGirl"].ToString()) : (bool?)null } ).ToList(); dataTable.Dispose(); } } } catch (Exception ex) { if (rdr != null) { rdr.Close(); rdr = null; } if (conn.State == ConnectionState.Open) { conn.Close(); } } #endregion //------------- Get Institute 4 Selected In Home --------- //============================================================ return(View(InstituteList)); }
public ActionResult InstituteList(string boy, string girl, int?ostan_code, int?city_code, int?zone_code, string search_text, int?page) { int Startindex = 0; int pagesize = 1; page = page.HasValue ? Convert.ToInt32(page) - 1 : 0; Startindex = page.HasValue ? Convert.ToInt32(page * pagesize) : 0; //pageIndex = string.IsNullOrEmpty(ViewBag.page) ? pageIndex : Convert.ToInt32(ViewBag.page); App_Start.ConnectionString constr = new App_Start.ConnectionString(); ConnectionString = constr.GetConnectionString(); SqlConnection conn = new SqlConnection(ConnectionString); SqlDataReader rdr = null; // ---------- boy -------------- if (boy == null) { boy = "1"; } //---------- girl --------------- if (girl == null) { girl = "1"; } //=================================================================== //------------------- Configure City institute --------------------- #region Configure City institute string city = ""; StringClass_Convert stringclass = new StringClass_Convert(); if (ostan_code != 0) { city = stringclass.Convert_to_4str(ostan_code); if (city_code != 0) { city = city + stringclass.Convert_to_4str(city_code); if (zone_code != 0) { city = city + stringclass.Convert_to_4str(zone_code); } } } else { city = ""; } #endregion Configure City institute //------------------- Configure City institute --------------------- //=================================================================== //=================================================================== //-------------- Boyor Girl Analyze ---------- #region Boy Or Girl Analyze string boyorgirl = ""; if (boy == "1" && girl == "0") { boyorgirl = "1"; } else if (boy == "0" && girl == "1") { boyorgirl = "0"; } else if (boy == "1" && girl == "1") { boyorgirl = "01"; } else if (boy == "0" && girl == "0") { boyorgirl = "00"; } #endregion //-------------- Boyor Girl Analyze ---------- //=================================================================== int Total_item = 0; int Total_page = 0; int?Current_page = page; //============================================================ //------------------------ Get Institute List Filter --------- List <ViewModel.InstituteSmallVM> InstituteList = new List <ViewModel.InstituteSmallVM>(); #region Get Institute List Filter try { if (conn.State != ConnectionState.Open) { conn.Open(); } string query = ""; #region Search Query query = @"select * from ( SELECT Institutes.id, Institutes.name,Institutes.En_Name, Institutes.[address],Institutes.boyOrGirl,Institutes.[order], (select InstituteKind.Name from InstituteKind where InstituteKind.id=Institutes.InstituteKindid) as InstituteKindName, ROW_NUMBER() OVER(order by Institutes.[order]) AS rownum FROM Institutes where Institutes.name like @name and (Institutes.Active is null or Institutes.Active =1) and Institutes.city_code like @city_code " ; if (boyorgirl == "1") { query += @"and (Institutes.boyOrGirl = 1 )"; } else if (boyorgirl == "0") { query += @"and (Institutes.boyOrGirl = 0 )"; } else if (boyorgirl == "01") { query += @"and (Institutes.boyOrGirl=1 or Institutes.boyOrGirl=0 or Institutes.boyOrGirl is null )"; } else if (boyorgirl == "00") { query += @""; } query += @") as Tbl_Institute where (Tbl_Institute.rownum>@CurrentPage and Tbl_Institute.rownum<=(@CurrentPage+@PageSize)) order by [order]" ; #endregion SqlCommand cmd = new SqlCommand(query, conn); cmd.Parameters.Add(new SqlParameter("@name", SqlDbType.NVarChar, 50)); if (search_text != null) { cmd.Parameters["@name"].Value = "%" + search_text + "%"; } else { cmd.Parameters["@name"].Value = "%" + "" + "%"; } cmd.Parameters.Add(new SqlParameter("@city_code", SqlDbType.NVarChar, 50)); cmd.Parameters["@city_code"].Value = city + "%"; cmd.Parameters.Add(new SqlParameter("@PageSize", SqlDbType.Int)); cmd.Parameters["@PageSize"].Value = pagesize; cmd.Parameters.Add(new SqlParameter("@CurrentPage", SqlDbType.Int)); cmd.Parameters["@CurrentPage"].Value = page; 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 ViewModel.InstituteSmallVM() { id = Int64.Parse(dr["id"].ToString()), name = dr["name"].ToString(), En_Name = dr["En_Name"].ToString(), InstituteKindName = dr["InstituteKindName"].ToString(), address = dr["address"].ToString(), boyOrGirl = dr["boyOrGirl"].ToString() != "" ? bool.Parse(dr["boyOrGirl"].ToString()) : (bool?)null } ).ToList(); dataTable.Dispose(); } } } catch (Exception ex) { if (rdr != null) { rdr.Close(); rdr = null; } if (conn.State == ConnectionState.Open) { conn.Close(); } } #endregion //------------------------ Get Institute List Filter --------- //============================================================ //============================================================ //-------------------- Get Total Item List Filter --------- #region Get Institute List Filter try { if (conn.State != ConnectionState.Open) { conn.Open(); } string query = ""; #region Search Query query = @"SELECT count(*) as TotalItem FROM Institutes where Institutes.name like @name and (Institutes.Active is null or Institutes.Active =1) and Institutes.city_code like @city_code " ; if (boyorgirl == "1") { query += @"and (Institutes.boyOrGirl = 1 )"; } else if (boyorgirl == "0") { query += @"and (Institutes.boyOrGirl = 0 )"; } else if (boyorgirl == "01") { query += @"and (Institutes.boyOrGirl=1 or Institutes.boyOrGirl=0 or Institutes.boyOrGirl is null )"; } else if (boyorgirl == "00") { query += @""; } #endregion SqlCommand cmd = new SqlCommand(query, conn); cmd.Parameters.Add(new SqlParameter("@name", SqlDbType.NVarChar, 50)); if (search_text != null) { cmd.Parameters["@name"].Value = "%" + search_text + "%"; } else { cmd.Parameters["@name"].Value = "%" + "" + "%"; } cmd.Parameters.Add(new SqlParameter("@city_code", SqlDbType.NVarChar, 50)); cmd.Parameters["@city_code"].Value = city + "%"; rdr = cmd.ExecuteReader(); DataTable dataTable = new DataTable(); dataTable.Load(rdr); if (dataTable != null) { if (dataTable.Rows.Count > 0) { DataRow dr = dataTable.Rows[0]; Total_item = dr["TotalItem"].ToString() != "" ? int.Parse(dr["TotalItem"].ToString()) : 0; dataTable.Dispose(); } } } catch (Exception ex) { if (rdr != null) { rdr.Close(); rdr = null; } if (conn.State == ConnectionState.Open) { conn.Close(); } } #endregion //------------------------ Get Institute List Filter --------- //============================================================ if (rdr != null) { rdr.Close(); rdr = null; } if (conn.State == ConnectionState.Open) { conn.Close(); } Total_page = Total_item / pagesize; //========================================== //---------------- Set ViewBag ------------- ViewBag.Total_item = Total_item; ViewBag.Total_page = Total_page; ViewBag.Current_page = Current_page; //---------------- Set ViewBag ------------- //========================================== return(PartialView("~/Views/Shared/Partial/_InstituteList.cshtml", InstituteList)); }
public ActionResult institutes() { App_Start.ConnectionString constr = new App_Start.ConnectionString(); ConnectionString = constr.GetConnectionString(); SqlConnection conn = new SqlConnection(ConnectionString); SqlDataReader rdr = null; //============================================================ //--------------------- Get Cities ------ List <City> tbl_ostan = new List <City>(); #region Get Institute Cities try { if (conn.State != ConnectionState.Open) { conn.Open(); } SqlCommand cmd = new SqlCommand(@"select Code,Pname from Cities where Code=State_Code and (active is null or active =1) order by Code", conn); rdr = cmd.ExecuteReader(); DataTable dataTable = new DataTable(); dataTable.Load(rdr); if (dataTable != null) { if (dataTable.Rows.Count > 0) { tbl_ostan = (from DataRow dr in dataTable.Rows select new City() { Code = int.Parse(dr["Code"].ToString()), Pname = dr["Pname"].ToString() } ).ToList(); ViewBag.ostanlist = tbl_ostan; dataTable.Dispose(); } } } catch (Exception ex) { if (rdr != null) { rdr.Close(); rdr = null; } if (conn.State == ConnectionState.Open) { conn.Dispose(); conn.Close(); } ViewModel.ViewBagError viewbagerror = new ViewModel.ViewBagError(); viewbagerror.ClassName = "alert-danger"; viewbagerror.Msg = "خطا در لود پایه های تحصیلی آموزشگاه : " + ex.Message; ViewBag.ErrorMsg = viewbagerror; } #endregion //--------------------- Get Cities ------ //============================================================ if (rdr != null) { rdr.Close(); rdr = null; } if (conn.State == ConnectionState.Open) { conn.Dispose(); conn.Close(); } ViewBag.Current_ostan = 0; return(View()); }
public IHttpActionResult UserLogin(string Username, string Password) { if (Username != null && Password != null) { //========================================================= //-------------------- Get User Institute ------ ViewModel.API.Login.LoginAPIResult CurrentLoginAPIResult = new ViewModel.API.Login.LoginAPIResult(); #region Get User Institute string ConnectionString; App_Start.ConnectionString constr = new App_Start.ConnectionString(); ConnectionString = constr.GetConnectionString(); SqlConnection conn = new SqlConnection(ConnectionString); SqlDataReader rdr = null; SqlDataReader rdrClass = null; SqlDataReader rdrAccess = null; try { if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlCommand cmd = new SqlCommand(@"SP_API_USER_Institutes", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Username", SqlDbType.NVarChar)); cmd.Parameters["@Username"].Value = Username; cmd.Parameters.Add(new SqlParameter("@Password", SqlDbType.NVarChar)); cmd.Parameters["@Password"].Value = Password; rdr = cmd.ExecuteReader(); DataTable dataTable = new DataTable(); DataTable dataTableClass = new DataTable(); DataTable dataTableAccess = new DataTable(); dataTable.Load(rdr); if (dataTable != null) { if ((dataTable.Rows.Count > 0)) { DataRow dr = dataTable.Rows[0]; #region Get User Information CurrentLoginAPIResult.Username = Username; CurrentLoginAPIResult.Password = Password; CurrentLoginAPIResult.Firstname = dr["firstname"].ToString(); CurrentLoginAPIResult.Lastname = dr["lastname"].ToString(); CurrentLoginAPIResult.token = NewTokenCode(Username, Password); #endregion //============================================================ //----------------- Get User Class Course ----- List <ViewModel.API.Login.classInfo> CurrentClassInfo = new List <ViewModel.API.Login.classInfo>(); #region Get User Class Course try { cmd = new SqlCommand(@"SP_API_CLASS_COURSE_USER", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Username", SqlDbType.NVarChar)); cmd.Parameters["@Username"].Value = Username; rdrClass = cmd.ExecuteReader(); dataTableClass.Load(rdrClass); if (dataTableClass != null) { if (dataTableClass.Rows.Count > 0) { foreach (DataRow itemclass in dataTableClass.Rows) { ViewModel.API.Login.classInfo myClassInfo = new ViewModel.API.Login.classInfo(); myClassInfo.id = int.Parse(itemclass["Calssid"].ToString()); myClassInfo.Instituteid = int.Parse(itemclass["Instituteid"].ToString()); myClassInfo.name = itemclass["Classname"].ToString(); myClassInfo.courseTitle = itemclass["Coursename"].ToString(); myClassInfo.studentsNumber = itemclass["StudentNumber"].ToString() != "" ? int.Parse(itemclass["StudentNumber"].ToString()) : 0; CurrentClassInfo.Add(myClassInfo); } } } } catch (Exception ex) { var msg = new HttpResponseMessage(HttpStatusCode.InternalServerError) { ReasonPhrase = "Internal Server Error!!!" }; throw new HttpResponseException(msg); } #endregion //----------------- Get User Class Course ----- //============================================================ //============================================================ //----------------- Get User Access ----- List <ViewModel.API.Login.AccessLevels> CurrentAccessLevels = new List <ViewModel.API.Login.AccessLevels>(); #region Get User Access try { cmd = new SqlCommand(@"SP_API_USER_ACCESS", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Username", SqlDbType.NVarChar)); cmd.Parameters["@Username"].Value = Username; rdrAccess = cmd.ExecuteReader(); dataTableAccess.Load(rdrAccess); if (dataTableAccess != null) { if (dataTableAccess.Rows.Count > 0) { foreach (DataRow itemaccess in dataTableAccess.Rows) { ViewModel.API.Login.AccessLevels myAccess = new ViewModel.API.Login.AccessLevels(); myAccess.Accessid = int.Parse(itemaccess["Accessid"].ToString()); myAccess.caption = itemaccess["caption"].ToString(); myAccess.Instituteid = int.Parse(itemaccess["Instituteid"].ToString()); CurrentAccessLevels.Add(myAccess); } } } } catch (Exception ex) { var msg = new HttpResponseMessage(HttpStatusCode.InternalServerError) { ReasonPhrase = "Internal Server Error!!!" }; throw new HttpResponseException(msg); } #endregion //----------------- Get User Access ----- //============================================================ CurrentLoginAPIResult.jobs = new List <ViewModel.API.Login.job>(); #region Get User Jobs foreach (DataRow item in dataTable.Rows) { ViewModel.API.Login.job Currentjob = new ViewModel.API.Login.job(); #region Get Job Name byte Manager_Teacher_Student_Parent = byte.Parse(item["Manager_Teacher_Student_Parent"].ToString()); if (Manager_Teacher_Student_Parent == 0) { Currentjob.name = "Manager"; } else if (Manager_Teacher_Student_Parent == 1) { Currentjob.name = "Teacher"; } else if (Manager_Teacher_Student_Parent == 2) { Currentjob.name = "Student"; } else if (Manager_Teacher_Student_Parent == 3) { Currentjob.name = "Parent"; } else if (Manager_Teacher_Student_Parent == 4) { Currentjob.name = "Employee"; } #endregion Currentjob.schools = new List <ViewModel.API.Login.School>(); ViewModel.API.Login.School CurrentSchool = new ViewModel.API.Login.School(); #region Get School Info CurrentSchool.id = int.Parse(item["Instituteid"].ToString()); CurrentSchool.name = item["name"].ToString(); #endregion CurrentSchool.classes = new List <ViewModel.API.Login.classInfo>(); #region Set ClassInfo School List <ViewModel.API.Login.classInfo> CurrentClassInfo_CurrentInstitute = CurrentClassInfo.Where(p => p.Instituteid == CurrentSchool.id).ToList(); foreach (var itemcalssinfo in CurrentClassInfo_CurrentInstitute) { CurrentSchool.classes.Add(itemcalssinfo); } #endregion Currentjob.schools.Add(CurrentSchool); Currentjob.accesseLevels = new List <ViewModel.API.Login.AccessLevels>(); List <ViewModel.API.Login.AccessLevels> CurrentAccess = CurrentAccessLevels.Where(p => p.Instituteid == CurrentSchool.id).ToList(); #region Set AccessLevel Job foreach (var itemaccess in CurrentAccess) { Currentjob.accesseLevels.Add(itemaccess); } #endregion CurrentLoginAPIResult.jobs.Add(Currentjob); } #endregion } else { var msg = new HttpResponseMessage(HttpStatusCode.Unauthorized) { ReasonPhrase = "Username Or Password Is Not Valid!!!" }; throw new HttpResponseException(msg); } } else { var msg = new HttpResponseMessage(HttpStatusCode.Unauthorized) { ReasonPhrase = "Username Or Password Is Not Valid!!!" }; throw new HttpResponseException(msg); } } catch (Exception ex) { var msg = new HttpResponseMessage(HttpStatusCode.InternalServerError) { ReasonPhrase = "Internal Server Error!!!" }; throw new HttpResponseException(msg); } #endregion //-------------------- Get User Institute ------ //========================================================= return(Ok(CurrentLoginAPIResult)); } else { var msg = new HttpResponseMessage(HttpStatusCode.Unauthorized) { ReasonPhrase = "Username Or Password Is Not Valid!!!" }; throw new HttpResponseException(msg); } }
public IHttpActionResult ListSchoolInfo() { List <ViewModel.API.School> SchoolInfoList = new List <ViewModel.API.School>(); string ConnectionString; App_Start.ConnectionString constr = new App_Start.ConnectionString(); ConnectionString = constr.GetConnectionString(); SqlConnection conn = new SqlConnection(ConnectionString); SqlDataReader rdr = null; //=========================================================================== //------------------------------- Get Cities ----------- List <Models.City> Cities = new List <Models.City>(); #region Get Cities try { if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlCommand cmd = new SqlCommand(@"select * from Cities where (active =1 or active is null)", conn); rdr = cmd.ExecuteReader(); DataTable dataTable = new DataTable(); dataTable.Load(rdr); if (dataTable != null) { if ((dataTable.Rows.Count > 0)) { Cities = (from DataRow dr in dataTable.Rows select new Models.City() { Code = Convert.ToInt32(dr["Code"].ToString()), State_Code = Convert.ToInt32(dr["State_Code"].ToString()), Pname = dr["Pname"].ToString(), Ename = dr["Ename"].ToString(), } ).ToList(); } } } catch (Exception ex) { if (rdr != null) { rdr.Close(); rdr = null; } if (conn.State == ConnectionState.Open) { conn.Close(); } var msg = new HttpResponseMessage(HttpStatusCode.InternalServerError) { ReasonPhrase = "Internal Server Error!!!" }; throw new HttpResponseException(msg); } #endregion //------------------------------- Get Cities ----------- //=========================================================================== //=========================================================================== //------------------------------- Get CityZones ----------- List <Models.CityZone> CityZones = new List <Models.CityZone>(); #region Get CityZones try { if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlCommand cmd = new SqlCommand(@"select * from CityZones where (active =1 or active is null)", conn); rdr = cmd.ExecuteReader(); DataTable dataTable = new DataTable(); dataTable.Load(rdr); if (dataTable != null) { if ((dataTable.Rows.Count > 0)) { CityZones = (from DataRow dr in dataTable.Rows select new Models.CityZone() { Code = Convert.ToInt32(dr["Code"].ToString()), Zone_Code = Convert.ToInt32(dr["Zone_Code"].ToString()), Pname = dr["Pname"].ToString(), Ename = dr["Ename"].ToString(), } ).ToList(); } } } catch (Exception ex) { if (rdr != null) { rdr.Close(); rdr = null; } if (conn.State == ConnectionState.Open) { conn.Close(); } var msg = new HttpResponseMessage(HttpStatusCode.InternalServerError) { ReasonPhrase = "Internal Server Error!!!" }; throw new HttpResponseException(msg); } #endregion //------------------------------- Get Cities ----------- //=========================================================================== //=========================================================================== //------------------------------- Get School List ----- #region Get School List try { if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlCommand cmd = new SqlCommand(@"select id,name,address,city_code,tel1,En_Name,Description,boyOrGirl,Edit_Date from Institutes where (Active =1 or Active is null)" , conn); rdr = cmd.ExecuteReader(); DataTable dataTable = new DataTable(); dataTable.Load(rdr); if (dataTable != null) { if ((dataTable.Rows.Count > 0)) { foreach (DataRow item in dataTable.Rows) { ViewModel.API.School CurrentSchool = new ViewModel.API.School(); CurrentSchool.about = item["Description"].ToString(); CurrentSchool.address = item["address"].ToString(); bool gender = item["boyOrGirl"].ToString() != "" ? bool.Parse(item["boyOrGirl"].ToString()) : true; if (gender == true) { CurrentSchool.gender = "پسرانه"; } else { CurrentSchool.gender = "دخترانه"; } CurrentSchool.id = int.Parse(item["id"].ToString()); CurrentSchool.lastRefreshed = item["Edit_Date"].ToString() != null ? item["Edit_Date"].ToString() : ""; //CurrentSchool.liked = ""; CurrentSchool.phoneNumber = item["tel1"].ToString(); CurrentSchool.schoolName = item["name"].ToString(); string url = ""; if (item["En_Name"].ToString() != "") { url = "http://egbaliye.forooshgahyas.ir/Content/images/schools/" + CurrentSchool.id + "/" + item["En_Name"].ToString() + "-main.JPG"; } CurrentSchool.imageUrl = url; int Zone_Code = 0, Code = 0, State_Code = 0; #region Analyze CityCode if (item["city_code"].ToString() != "") { string CityCode = item["city_code"].ToString(); if (CityCode.Length >= 4) { string provinceCode = CityCode.Substring(0, 4); if (provinceCode != "") { Code = int.Parse(provinceCode); if (CityCode.Length >= 8) { string townCode = CityCode.Substring(4, 4); if (townCode != "") { State_Code = int.Parse(townCode); if (CityCode.Length >= 12) { string regionCode = CityCode.Substring(8, 4); if (regionCode != "") { Zone_Code = int.Parse(regionCode); } } } } } } } #endregion Models.City CurrentCity = Cities.Where(p => p.Code == Code && p.State_Code == Code).FirstOrDefault(); if (CurrentCity != null) { CurrentSchool.province = CurrentCity.Pname; } CurrentCity = Cities.Where(p => p.Code == State_Code && p.State_Code == Code).FirstOrDefault(); if (CurrentCity != null) { CurrentSchool.town = CurrentCity.Pname; } Models.CityZone myzone = CityZones.Where(p => p.Code == State_Code && p.Zone_Code == Zone_Code).FirstOrDefault(); if (myzone != null) { CurrentSchool.region = myzone.Zone_Code; } SchoolInfoList.Add(CurrentSchool); } } } } catch (Exception ex) { if (rdr != null) { rdr.Close(); rdr = null; } if (conn.State == ConnectionState.Open) { conn.Close(); } var msg = new HttpResponseMessage(HttpStatusCode.InternalServerError) { ReasonPhrase = "Internal Server Error!!!" }; throw new HttpResponseException(msg); } #endregion //------------------------------- Get School List ----- //=========================================================================== if (rdr != null) { rdr.Close(); rdr = null; } if (conn.State == ConnectionState.Open) { conn.Close(); } return(Ok(SchoolInfoList)); }
public ActionResult Employee_list(int?page) { int pageIndex = 1; int pagesize = 2; pageIndex = page.HasValue ? Convert.ToInt32(page) : 1; IPagedList <ViewModel.EmployeeList_VM> result = null; User userinfo = (User)Session["User"]; #region Get Session ViewModel.Institute_Info_Session_VM Institute_info_Session = new ViewModel.Institute_Info_Session_VM(); if (Session["Institute_info"] != null) { Institute_info_Session = (ViewModel.Institute_Info_Session_VM)Session["Institute_info"]; } else { Institute_info_Session = null; } #endregion if (Institute_info_Session != null) { App_Start.ConnectionString constr = new App_Start.ConnectionString(); ConnectionString = constr.GetConnectionString(); SqlConnection conn = new SqlConnection(ConnectionString); SqlDataReader rdr = null; //============================================================ //--------------------- Get Employee List in Class id --- List <ViewModel.EmployeeList_VM> EmployeeList = new List <ViewModel.EmployeeList_VM>(); #region Get Employee List in Institute id try { if (conn.State != ConnectionState.Open) { conn.Open(); } SqlCommand cmd = new SqlCommand(@"select Users.username,Users.firstname,Users.lastname,Users.gender, case When User_Jobs.Jobid = 1 Then Users.Manager_Code When User_Jobs.Jobid = 2 Then Users.Teacher_Code When User_Jobs.Jobid = 5 Then Users.Employe_Code End as Code , (select Jobs.Name from Jobs where Jobs.id = User_Jobs.Jobid) as JobName from User_Jobs inner join Users On User_Jobs.Instituteid =@Instituteid and (User_Jobs.Jobid != 3 and User_Jobs.Jobid != 4) and Users.username like User_Jobs.Username ", conn); cmd.Parameters.Add(new SqlParameter("@Instituteid", SqlDbType.Int)); cmd.Parameters["@Instituteid"].Value = Institute_info_Session.id; rdr = cmd.ExecuteReader(); DataTable dataTable = new DataTable(); dataTable.Load(rdr); if (dataTable != null) { if (dataTable.Rows.Count > 0) { EmployeeList = (from DataRow dr in dataTable.Rows select new ViewModel.EmployeeList_VM() { username = dr["username"].ToString(), firstname = dr["firstname"].ToString(), lastname = dr["lastname"].ToString(), gender = dr["gender"].ToString() != "" ? bool.Parse(dr["gender"].ToString()) : (bool?)null, Code = dr["Code"].ToString(), JobName = dr["JobName"].ToString() } ).ToList(); dataTable.Dispose(); } } } catch (Exception ex) { if (rdr != null) { rdr.Close(); rdr = null; } if (conn.State == ConnectionState.Open) { conn.Dispose(); conn.Close(); } ViewModel.ViewBagError viewbagerror = new ViewModel.ViewBagError(); viewbagerror.ClassName = "alert-danger"; viewbagerror.Msg = "خطا در لود لیست کارمندان : " + ex.Message; ViewBag.ErrorMsg = viewbagerror; } #endregion //--------------------- Get Employee List in Class id --- //============================================================ result = EmployeeList.ToPagedList(pageIndex, pagesize); return(View("~/Views/maindashboard/Employee/Employeelist.cshtml", result)); } else { ViewModel.ViewBagError viewbagerror = new ViewModel.ViewBagError(); viewbagerror.ClassName = "alert-danger"; viewbagerror.Msg = "شناسه آموزشگاه صحیح نیست."; ViewBag.ErrorMsg = viewbagerror; return(View("~/Views/maindashboard/Employee/Employeelist.cshtml")); } }
public override void OnActionExecuting(HttpActionContext actionContext) { if (Need) { string query = actionContext.Request.RequestUri.Query; var accessToken = HttpContext.Current; var TokenCode = accessToken.Request.Headers["Authorization"]; if (TokenCode != null) { string t = TokenCode.Replace("Bearer ", ""); TokenCode = t; } //==================================================================== //---------------------- Get Information For APILog --------------------- #region Get Information For Log string actionName = actionContext.ActionDescriptor.ActionName; string controllerName = actionContext.ActionDescriptor.ControllerDescriptor.ControllerName; var values = actionContext.ActionArguments.Values; string verb = Convert.ToString(actionContext.ControllerContext.Request.Method); string routevalue = ""; string querrystring = string.Empty; for (int i = 0; i < values.Count(); i++) { if (values.ElementAt(i) != null) { var item = HttpContext.Current.Request.QueryString.Keys[i]; string name = values.ElementAt(i).ToString(); string value = values.ElementAt(i).ToString(); routevalue = routevalue + item + "=" + value; } if (i + 1 < values.Count) { routevalue = routevalue + "&"; } } string ip = GetClientIpAddress(actionContext.Request); string browser = GetBrowser(actionContext.Request); string OS = GetClientOS(actionContext.Request); string Description = null; var context = actionContext.RequestContext; #endregion Get Information For Log //---------------------- Get Information For Log --------------------- //==================================================================== //==================================================================== //----------------------- Insert Log to Tbl APILog ---------------------- #region Insert Log to Tbl APILog string ConnectionString; App_Start.ConnectionString constr = new App_Start.ConnectionString(); ConnectionString = constr.GetConnectionString(); // 1. Instantiate the connection SqlConnection conn = new SqlConnection(ConnectionString); try { conn.Open(); SqlCommand cmd = new SqlCommand(@"INSERT INTO APILogs (Controller, Action, IP, Date, OS, Browser, Description,TokenCode) VALUES (@Controller, @Action, @IP, @Date, @OS, @Browser, @Description,@TokenCode)", conn); cmd.Parameters.Add(new SqlParameter("@Controller", SqlDbType.NVarChar, 50)); cmd.Parameters["@Controller"].Value = controllerName; cmd.Parameters.Add(new SqlParameter("@Action", SqlDbType.NVarChar, 50)); cmd.Parameters["@Action"].Value = actionName + " - " + routevalue; cmd.Parameters.Add(new SqlParameter("@IP", SqlDbType.NVarChar, 50)); cmd.Parameters["@IP"].Value = ip; cmd.Parameters.Add(new SqlParameter("@Date", SqlDbType.DateTime)); cmd.Parameters["@Date"].Value = DateTime.Now; cmd.Parameters.Add(new SqlParameter("@OS", SqlDbType.NVarChar, 50)); if (OS != null) { cmd.Parameters["@OS"].Value = OS; } else { cmd.Parameters["@OS"].Value = DBNull.Value; } cmd.Parameters.Add(new SqlParameter("@Browser", SqlDbType.NVarChar, 50)); if (OS != null) { cmd.Parameters["@Browser"].Value = browser; } else { cmd.Parameters["@Browser"].Value = DBNull.Value; } cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.NVarChar)); if (Description != null) { cmd.Parameters["@Description"].Value = Description; } else { cmd.Parameters["@Description"].Value = DBNull.Value; } cmd.Parameters.Add(new SqlParameter("@TokenCode", SqlDbType.NVarChar)); if (TokenCode != null) { cmd.Parameters["@TokenCode"].Value = TokenCode; } else { cmd.Parameters["@TokenCode"].Value = DBNull.Value; } cmd.ExecuteNonQuery(); conn.Close(); } catch (Exception ex) { conn.Close(); } #endregion Insert Log to Tbl Log //----------------------- Insert Log to Tbl Log ---------------------- //==================================================================== } base.OnActionExecuting(actionContext); }
public ActionResult Index(string username, string password) { if (username != null && password != null) { App_Start.ConnectionString constr = new App_Start.ConnectionString(); ConnectionString = constr.GetConnectionString(); SqlConnection conn = new SqlConnection(ConnectionString); SqlDataReader rdr = null; try { //===================================== //------------ Get User Info -------- User user = new User(); #region Get User Info try { if (conn.State != ConnectionState.Open) { conn.Open(); } SqlCommand cmd = new SqlCommand(@"select username,firstname,lastname,gender from Users where username like @username and password like @password and (Active is null or Active =1 ) ", conn); cmd.Parameters.Add(new SqlParameter("@username", SqlDbType.NVarChar, 50)); cmd.Parameters["@username"].Value = username; cmd.Parameters.Add(new SqlParameter("@password", SqlDbType.NVarChar)); cmd.Parameters["@password"].Value = password; rdr = cmd.ExecuteReader(); DataTable dataTable = new DataTable(); dataTable.Load(rdr); if (dataTable != null) { if (dataTable.Rows.Count > 0) { DataRow dr = dataTable.Rows[0]; user.username = dr["username"].ToString(); user.firstname = dr["firstname"].ToString(); user.lastname = dr["lastname"].ToString(); user.gender = dr["gender"].ToString() != "" ? bool.Parse(dr["gender"].ToString()) :(bool?)null; Session["User"] = user; dataTable.Dispose(); } } } catch (Exception ex) { if (rdr != null) { rdr.Close(); rdr = null; } if (conn.State == ConnectionState.Open) { conn.Dispose(); conn.Close(); } } #endregion //------------ Get User Info -------- //===================================== if (user.username != null) { //===================================== //------------ get user access -------- #region Get User Access try { if (conn.State != ConnectionState.Open) { conn.Open(); } SqlCommand cmd = new SqlCommand(@"select Accesses.caption,Accesses.Instituteid from UserAccesses inner join Accesses ON UserAccesses.Username like @username and Accesses.id=UserAccesses.id and (Accesses.Active is null or Accesses.Active=1) ", conn); cmd.Parameters.Add(new SqlParameter("@username", SqlDbType.NVarChar, 50)); cmd.Parameters["@username"].Value = username; rdr = cmd.ExecuteReader(); DataTable dataTable = new DataTable(); dataTable.Load(rdr); if (dataTable != null) { if (dataTable.Rows.Count > 0) { List <Access> accesses = new List <Access>(); accesses = (from DataRow dr in dataTable.Rows select new Access() { caption = dr["caption"].ToString(), Instituteid = int.Parse(dr["Instituteid"].ToString()) } ).ToList(); Session["Access"] = accesses; dataTable.Dispose(); } } } catch (Exception ex) { if (rdr != null) { rdr.Close(); rdr = null; } if (conn.State == ConnectionState.Open) { conn.Dispose(); conn.Close(); } } #endregion //------------ get user access -------- //===================================== //===================================== //------------ get user job ----------- #region User Jobs try { if (conn.State != ConnectionState.Open) { conn.Open(); } SqlCommand cmd = new SqlCommand(@"select Jobs.id,Jobs.Caption,User_Jobs.Instituteid from User_Jobs inner join Jobs ON User_Jobs.Username like @Username and Jobs.id = User_Jobs.Jobid and (Jobs.Active is null or Jobs.Active =1) ", conn); cmd.Parameters.Add(new SqlParameter("@Username", SqlDbType.NVarChar, 50)); cmd.Parameters["@Username"].Value = username; rdr = cmd.ExecuteReader(); DataTable dataTable = new DataTable(); dataTable.Load(rdr); if (dataTable != null) { if (dataTable.Rows.Count > 0) { List <ViewModel.User_Jobs_VM> jobs = new List <ViewModel.User_Jobs_VM>(); jobs = (from DataRow dr in dataTable.Rows select new ViewModel.User_Jobs_VM() { id = Int64.Parse(dr["id"].ToString()), Caption = dr["Caption"].ToString(), Instituteid = Int64.Parse(dr["Instituteid"].ToString()) } ).ToList(); Session["Job"] = jobs; dataTable.Dispose(); } } } catch (Exception ex) { if (rdr != null) { rdr.Close(); rdr = null; } if (conn.State == ConnectionState.Open) { conn.Dispose(); conn.Close(); } } #endregion //------------ get user job ----------- //===================================== return(RedirectToAction("Index", "Home")); } else { ViewBag.result = "نام کاربری یا رمز عبور صحیح نیست ."; } } catch (Exception ex) { ViewBag.result = "سیستم با خطا مواجه شد ."; } } return(View("Index", null)); }