public static int GetClientID(string path) { HttpContext context = HttpContext.Current; var datacontext = new Data.dbml.DataContext(Common.DataConnectionString); var tbl = datacontext.TBL_Organization.FirstOrDefault(o => o.SubDomain == path); return tbl.OrganizationId; }
public static int GetClientID(string path) { HttpContext context = HttpContext.Current; var datacontext = new Data.dbml.DataContext(Common.DataConnectionString); var tbl = datacontext.TBL_Organization.FirstOrDefault(o => o.SubDomain == path); return(tbl.OrganizationId); }
public void BeginRequest(Object source, EventArgs e) { HttpApplication context = (HttpApplication)source; string path = context.Request.Path.Split('/').First(); if (!string.IsNullOrEmpty(path)) { var datacontext = new Data.dbml.DataContext(Common.DataConnectionString); var tbl = datacontext.TBL_Organization.FirstOrDefault(o => o.SubDomain == path); if (tbl != null) context.Response.Cookies.Add(new HttpCookie("client", tbl.OrganizationId.ToString())); } }
public void BeginRequest(Object source, EventArgs e) { HttpApplication context = (HttpApplication)source; string path = context.Request.Path.Split('/').First(); if (!string.IsNullOrEmpty(path)) { var datacontext = new Data.dbml.DataContext(Common.DataConnectionString); var tbl = datacontext.TBL_Organization.FirstOrDefault(o => o.SubDomain == path); if (tbl != null) { context.Response.Cookies.Add(new HttpCookie("client", tbl.OrganizationId.ToString())); } } }
protected void EndRequest(HttpContext context) { //if (_GetDataContext4 != null) // _GetDataContext4 = null; //if (_GetDataContext3 != null) // _GetDataContext3 = null; if (_GetDataContext2 != null) { _GetDataContext2.Dispose(); _GetDataContext2 = null; } if (_GetDataContext1 != null) { _GetDataContext1.Dispose(); _GetDataContext1 = null; } _connections.ForEach(o => o.Close()); }
protected void EndRequest(HttpContext context) { if (_GetDataContext4 != null) { _GetDataContext4 = null; } if (_GetDataContext3 != null) { _GetDataContext3 = null; } if (_GetDataContext2 != null) { _GetDataContext2.Dispose(); _GetDataContext2 = null; } if (_GetDataContext1 != null) { _GetDataContext1.Dispose(); _GetDataContext1 = null; } Common.WriteCookieValues(); }
private void SaveUploadedPin(HttpContext context) { int board = int.Parse(context.Request.Params["board"]); string desc = context.Request.Params["desc"]; string img = context.Request.Params["img"]; IHash fnv1a = HashFactory.Hash64.CreateFNV1a(); IHash crc64 = HashFactory.Checksum.CreateCRC64b(); IHash murmur2 = HashFactory.Hash64.CreateMurmur2(); Uri url = new Uri(img); string image = url.Segments.Last(); string fp = Path.Combine(Common.Temp, Common.UserID.ToString(), image); FileInfo fInfo = new FileInfo(fp); string destRel = Common.UploadedImageRelPath + Common.UserID; string dest = Common.UploadedImagePath + Common.UserID; string destFileName = Common.MoveAndRenameFileIfExists(fInfo, dest); string relPath = Common.UserID + "/" + destFileName; byte[] _d = File.ReadAllBytes(Path.Combine(dest, destFileName)); ulong _crc64; ulong _murmur2; ulong _fnv1a; short height, width; int imageID = 0; CalcHash(_d, out _crc64, out _murmur2, out _fnv1a, out height, out width); using (TransactionScope scope = new TransactionScope()) { try { Data.dbml.DataContext _context = this.GetDataContext2; var imgtb = _context.Images.Where(o => o.FNV1a == _fnv1a && o.CRC64 == _crc64 && o.MURMUR2 == _murmur2).FirstOrDefault(); var theboard = _context.Boards.Where(o => o.ID == board).Single(); if (imgtb == null) //only one image entry can exists { Data.dbml.Images i = new Data.dbml.Images(); i.CRC64 = _crc64; i.MURMUR2 = _murmur2; i.FNV1a = _fnv1a; i.Image_Height = height; i.Image_Width = width; i.Uploaded = true; i.Tagged = true; i.RelativeImage_Path = relPath; _context.Images.InsertOnSubmit(i); _context.SubmitChanges(); imageID = i.ID; } else { imageID = imgtb.ID; } Data.dbml.BoardsImagesMapping bim = new Data.dbml.BoardsImagesMapping(); bim.BoardID = board; bim.ImageID = imageID; bim.Image_Title = desc; bim.UserID = Common.UserID; _context.BoardsImagesMapping.InsertOnSubmit(bim); Data.dbml.CategoryImagesMapping cim = new Data.dbml.CategoryImagesMapping(); cim.CategoryID = theboard.CatID; cim.ImageID = imageID; _context.CategoryImagesMapping.InsertOnSubmit(cim); UpdatePoints(Common.PointsNewPin); _context.SubmitChanges(); UpdateUPCount(); scope.Complete(); context.WriteJsonP(JsonConvert.SerializeObject(new { PinID = ((ulong)bim.ID + _crc64).ToString() })); } catch (Exception e) { throw; } finally { scope.Dispose(); } } }
private void SaveAddedPin(HttpContext context) { int board = int.Parse(context.Request.Params["board"]); string desc = context.Request.Params["desc"]; string img = context.Request.Params["img"]; string destRel = Common.UploadedImageRelPath + Common.UserID; string dest = Common.UploadedImagePath + Common.UserID; string destFileName = Guid.NewGuid().ToString() + ".jpg"; string destFileFullPath = Path.Combine(dest, destFileName); WebClient client = new WebClient(); MemoryStream ms = new MemoryStream(client.DownloadData(img)); using (Image image = Image.FromStream(ms)) { if (!Directory.Exists(dest)) { Directory.CreateDirectory(dest); } image.Save(destFileFullPath, ImageFormat.Jpeg); } string relPath = Common.UserID + "/" + destFileName; byte[] _d = File.ReadAllBytes(destFileFullPath); ulong _crc64; ulong _murmur2; ulong _fnv1a; short height, width; int imageID = 0; CalcHash(_d, out _crc64, out _murmur2, out _fnv1a, out height, out width); using (TransactionScope scope = new TransactionScope()) { try { Data.dbml.DataContext _context = this.GetDataContext2; var imgtb = _context.Images.Where(o => o.FNV1a == _fnv1a).FirstOrDefault(); var theboard = _context.Boards.Where(o => o.ID == board).Single(); if (imgtb == null) //only one image entry can exists { Data.dbml.Images i = new Data.dbml.Images(); i.CRC64 = _crc64; i.MURMUR2 = _murmur2; i.Tagged = true; i.FNV1a = _fnv1a; i.Image_Height = height; i.Image_Width = width; i.Uploaded = true; i.RelativeImage_Path = relPath; _context.Images.InsertOnSubmit(i); _context.SubmitChanges(); imageID = i.ID; } else { imageID = imgtb.ID; } Data.dbml.BoardsImagesMapping bim = new Data.dbml.BoardsImagesMapping(); bim.BoardID = board; bim.ImageID = imageID; bim.Image_Title = desc; bim.Source = img; bim.UserID = Common.UserID.Value; _context.BoardsImagesMapping.InsertOnSubmit(bim); Data.dbml.CategoryImagesMapping cim = new Data.dbml.CategoryImagesMapping(); cim.CategoryID = theboard.CatID; cim.ImageID = imageID; _context.CategoryImagesMapping.InsertOnSubmit(cim); UpdatePoints(Common.PointsNewPin); _context.SubmitChanges(); UpdateUPCount(); scope.Complete(); context.WriteJsonP(JsonConvert.SerializeObject(new { PinID = (_crc64 + (ulong)bim.ID).ToString() })); } catch (Exception e) { throw; } finally { scope.Dispose(); } } }
protected void EndRequest(HttpContext context) { if (_GetDataContext4 != null) _GetDataContext4 = null; if (_GetDataContext3 != null) _GetDataContext3 = null; if (_GetDataContext2 != null) { _GetDataContext2.Dispose(); _GetDataContext2 = null; } if (_GetDataContext1 != null) { _GetDataContext1.Dispose(); _GetDataContext1 = null; } Common.WriteCookieValues(); }