public ActionResult Remove(string[] fileNames) { PictureRepository picRep = new PictureRepository(); int NewPicID = picRep.GetLastPictureId(Convert.ToInt32(HttpContext.Session["ClientId"])); // The parameter of the Remove action must be called "fileNames" foreach (var fullName in fileNames) { var fileName = Path.GetFileName(fullName); var extention = fileName.Substring(fileName.IndexOf('.')); var newfilename = NewPicID.ToString() + extention; // Check if Path exsits string serverpath = Server.MapPath("~/Images/Client/" + HttpContext.Session["ClientId"].ToString() + "/Ads"); if (!Directory.Exists(serverpath)) { Directory.CreateDirectory(serverpath); } var physicalPath = Path.Combine(Server.MapPath("~/Images/Client/" + HttpContext.Session["ClientId"].ToString() + "/Ads"), newfilename); // TODO: Verify user permissions if (System.IO.File.Exists(physicalPath)) { // The files are not actually removed in this demo System.IO.File.Delete(physicalPath); picRep.RemovePicture(NewPicID); } } // Return an empty string to signify success return Content(""); }
public List<Schoolsc> GetListSchools(int ClientId) { List<Schoolsc> list = new List<Schoolsc>(); Schoolsc ins; //...Database Connection... DataBaseConnection dbConn = new DataBaseConnection(); SqlConnection con = dbConn.SqlConn(); SqlCommand cmdI; //...SQL Commands... cmdI = new SqlCommand("SELECT * from Schools WHERE ClientId = " + ClientId + " ORDER BY SchoolId DESC", con); cmdI.Connection.Open(); SqlDataReader drI = cmdI.ExecuteReader(); //...Retrieve Data... if (drI.HasRows) { while (drI.Read()) { ins = new Schoolsc(); ins.SchoolId = Convert.ToInt32(drI["SchoolId"]); ins.ClientId = Convert.ToInt32(drI["ClientId"]); ins.SchoolName = drI["SchoolName"].ToString(); ins.Schoolabbreviation = drI["Schoolabbreviation"].ToString(); ins.PictureId = Convert.ToInt32(drI["PictureId"]); list.Add(ins); } } drI.Close(); con.Close(); PictureRepository picRep = new PictureRepository(); foreach (Schoolsc item in list) { if (item.PictureId != 0) { item.PicUrl = picRep.GetPicture(item.PictureId).PicUrl; /*if (item.PicUrl.Contains("\\Images\\")) { string path = item.PicUrl.Substring(item.PicUrl.IndexOf("\\Images\\")); path = path.Replace('\\', '/'); item.PicUrl = "http://www.netintercom.co.za" + path; }*/ } } return list; }
public ActionResult Save(IEnumerable<HttpPostedFileBase> attachments) { PictureRepository picRep = new PictureRepository(); Functions functions = new Functions(); // The Name of the Upload component is "attachments" int NewPicID = picRep.GetLastPictureId(Convert.ToInt32(HttpContext.Session["ClientId"])); NewPicID++; Picture ins = new Picture(); foreach (var file in attachments) { // Some browsers send file names with full path. This needs to be stripped. var fileName = Path.GetFileName(file.FileName); var extention = fileName.Substring(fileName.IndexOf('.')); var newfilename = NewPicID.ToString() + extention; // Check if Path exsits string serverpath = Server.MapPath("~/Images/Client/" + HttpContext.Session["ClientId"].ToString() + "/Ads"); if (!Directory.Exists(serverpath)) { Directory.CreateDirectory(serverpath); } var physicalPath = Path.Combine(Server.MapPath("~/Images/Client/" + HttpContext.Session["ClientId"].ToString() + "/Ads"), newfilename); //...Resize.. Image original = Image.FromStream(file.InputStream, true, true); Image resized = functions.ResizeImage(original, new Size(500, 500)); resized.Save(physicalPath, ImageFormat.Jpeg); string finalpath = physicalPath.ToString(); finalpath = finalpath.Substring(finalpath.IndexOf("Images")); finalpath = finalpath.Replace('\\', '/'); //...Save In DB... ins.PicUrl = Constants.HTTPPath + finalpath; ins.ClientId = Convert.ToInt32(HttpContext.Session["ClientId"]); ins = picRep.InsertPicture(ins); } // Return an empty string to signify success if (ins.PictureId != 0) return Json(new { status = ins.PictureId.ToString() }, "text/plain"); else return Json(new { status = "0" }, "text/plain"); }
public void RemoveSchoolData(int ClientId) { PictureRepository picrep = new PictureRepository(); picrep.RemoveSchoolPictures(ClientId); NotificationsRepository nrep = new NotificationsRepository(); nrep.RemoveSchoolNotificationss(ClientId); EventRepository erep = new EventRepository(); erep.RemoveSchoolEvents(ClientId); AdvertisementRepository arep = new AdvertisementRepository(); arep.RemoveClientAdvertisement(ClientId); NewsRepository nerep = new NewsRepository(); nerep.RemoveSchoolNewss(ClientId); ContactRepository crep = new ContactRepository(); crep.RemoveSchoolContacts(ClientId); }
public ActionResult _DeleteEvent(int id) { PictureRepository picRep = new PictureRepository(); Event ins = EventRep.GetEvent(id); if (ins.PictureId != 0) { //...Get Picture... Picture pic = picRep.GetPicture(ins.PictureId); string path = pic.PicUrl.Substring(pic.PicUrl.IndexOf("/Images/") + 8); path = path.Replace('/', '\\'); var finalpath = Path.Combine(Server.MapPath("~/Images"), path); System.IO.File.Delete(finalpath); bool picrem = picRep.RemovePicture(ins.PictureId); } bool ins2 = EventRep.RemoveEvent(id); //...Notify... string regIds = AppRep.GetAllRegIds(Convert.ToInt32(HttpContext.Session["ClientId"])); if (!regIds.Equals("")) { comrep.NewUpdateData(regIds, "CMD_DELEVENT", id.ToString()); } //...Repopulate Grid... List<Event> lst = new List<Event>(); lst = EventRep.GetListEvent(Convert.ToInt32(HttpContext.Session["ClientId"])); return View(new GridModel(lst)); }
public List<News> GetListNews(int ClientId) { List<News> list = new List<News>(); News ins; //...Database Connection... DataBaseConnection dbConn = new DataBaseConnection(); SqlConnection con = dbConn.SqlConn(); SqlCommand cmdI; //...SQL Commands... cmdI = new SqlCommand("SELECT * FROM News WHERE ClientId = " + ClientId + " ORDER BY NewsId DESC", con); cmdI.Connection.Open(); SqlDataReader drI = cmdI.ExecuteReader(); //...Retrieve Data... if (drI.HasRows) { while (drI.Read()) { ins = new News(); ins.NewsId = Convert.ToInt32(drI["NewsId"]); ins.ClientId = Convert.ToInt32(drI["ClientId"]); ins.CategoryId = Convert.ToInt32(drI["CategoryId"]); ins.SubCategoryId = Convert.ToInt32(drI["SubCategoryId"]); ins.PictureId = Convert.ToInt32(drI["PictureId"]); ins.Title = drI["Title"].ToString(); ins.Body = drI["Body"].ToString(); ins.PostDate = Convert.ToDateTime(drI["PostDate"]); list.Add(ins); } } drI.Close(); con.Close(); PictureRepository picRep = new PictureRepository(); foreach(News item in list) { if (item.PictureId != 0) { item.PicUrl = picRep.GetPicture(item.PictureId).PicUrl; /*if (item.PicUrl.Contains("\\Images\\")) { string path = item.PicUrl.Substring(item.PicUrl.IndexOf("\\Images\\")); path = path.Replace('\\', '/'); item.PicUrl = "http://www.netintercom.co.za" + path; }*/ } } return list; }
public List<Teams> GetListTeams(int ClientId) { List<Teams> list = new List<Teams>(); Teams ins; //...Database Connection... DataBaseConnection dbConn = new DataBaseConnection(); SqlConnection con = dbConn.SqlConn(); SqlCommand cmdI; //...SQL Commands... cmdI = new SqlCommand("SELECT t.*,sc.CategoryName,sch.* FROM Teams t inner join SportCategory sc on t.SportCategoryID = sc.SportCategoryId inner join Schools sch on t.SchoolId =sch.SchoolId WHERE t.ClientId = " + ClientId + " ORDER BY t.TeamsId DESC", con); cmdI.Connection.Open(); SqlDataReader drI = cmdI.ExecuteReader(); //...Retrieve Data... if (drI.HasRows) { while (drI.Read()) { ins = new Teams(); ins.TeamsId = Convert.ToInt32(drI["TeamsId"]); ins.ClientId = Convert.ToInt32(drI["ClientId"]); ins.Name = drI["Schoolabbreviation"].ToString(); ins.Age = drI["Age"].ToString(); ins.Ranks = drI["Ranks"].ToString(); ins.SportCategoryID = Convert.ToInt32(drI["SportCategoryID"]); ins.sportcategory = drI["CategoryName"].ToString(); ins.SchoolId = Convert.ToInt32(drI["SchoolId"]); ins.schoolname = drI["SchoolName"].ToString(); ins.PictureId = Convert.ToInt32(drI["PictureId"]); list.Add(ins); } } drI.Close(); con.Close(); PictureRepository picRep = new PictureRepository(); foreach (Teams item in list) { if (item.PictureId != 0) { item.PicUrl = picRep.GetPicture(item.PictureId).PicUrl; /*if (item.PicUrl.Contains("\\Images\\")) { string path = item.PicUrl.Substring(item.PicUrl.IndexOf("\\Images\\")); path = path.Replace('\\', '/'); item.PicUrl = "http://www.netintercom.co.za" + path; }*/ } } return list; }