/// <summary> /// /// </summary> /// <param name="entityKey"></param> public static void Delete(int entityKey) { using (var context = new EntitiesContext()) { DAL.PortalAlia r = context.PortalAlias.Single(p => p.PortalAliasID == entityKey); context.DeleteObject(r); context.SaveChanges(); } }
public static void InsertLog(int _ClientHeight, int _ClientWidth, string _FileName, bool _Ajax) { try { string _Host = HttpContext.Current.Request.Url.Host; int _UserID = 0; HttpBrowserCapabilities r = HttpContext.Current.Request.Browser; if (HttpContext.Current.Session["UserID"] != null) { _UserID = (int)HttpContext.Current.Session["UserID"]; } using (EntitiesContext context = new EntitiesContext()) { DAL.SiteLog L = new DAL.SiteLog { PortalID = SiteLog.PortalID, CreateDate = DateTime.Now, UserID = _UserID, Ajax = _Ajax, Host = _Host, FileName = _FileName.Replace("ACTION=", "/"), RequestRequestType = HttpContext.Current.Request.RequestType, RequestUserHostAddress = HttpContext.Current.Request.UserHostAddress, RequestUserHostName = HttpContext.Current.Request.UserHostName, RequestHttpMethod = HttpContext.Current.Request.HttpMethod, ClientHeight = _ClientHeight, ClientWidth = _ClientWidth, Browser = r.Browser, BrowserType = r.Type, BrowserVersion = decimal.Parse(r.Version), BrowserMajorVersion = r.MajorVersion, BrowserPlatform = r.Platform, BrowserCrawler = r.Crawler, BrowserFrames = r.Frames, BrowserTables = r.Tables, BrowserCookies = r.Cookies, BrowserVBScript = r.VBScript, BrowserEcmaScriptVersion = decimal.Parse(r.EcmaScriptVersion.ToString()), BrowserJavaApplets = r.JavaApplets, BrowserActiveXControls = r.ActiveXControls, BrowserJavaScriptVersion = decimal.Parse(r["JavaScriptVersion"]) }; context.SiteLogs.AddObject(L); context.SaveChanges(); } } catch (Exception ex) { ElmahExtension.LogToElmah(ex); } }
public void UpdateItemPath(string path, string newName, int newParentId) { int fileID = GetItemId(path); if (fileID < 0) { return; } using (EntitiesContext context = new EntitiesContext()) { //var I = context.ContentFiles.FirstOrDefault(i => i.FileID == fileID & i.PortalID == Portals.PortalID); var I = context.ContentFiles.FirstOrDefault(i => i.FileID == fileID); I.Name = newName; I.ParentID = newParentId; context.SaveChanges(); } _data = null; }
public void ReplaceItemContent(string path, byte[] content) { int fileID = GetItemId(path); if (fileID < 0) { return; } using (EntitiesContext context = new EntitiesContext()) { //var I = context.ContentFiles.FirstOrDefault(i => i.FileID == fileID & i.PortalID == Portals.PortalID); var I = context.ContentFiles.FirstOrDefault(i => i.FileID == fileID); I.FileContent = content; context.SaveChanges(); } }
public void DeleteItem(string path) { //TODO: cascade delete when removing a non-empty folder int itemId = GetItemId(path); if (itemId <= 0) { return; } using (EntitiesContext context = new EntitiesContext()) { //dynamic I = context.ContentFiles.FirstOrDefault(i => i.FileID == itemId & i.PortalID == Portals.PortalID); dynamic I = context.ContentFiles.FirstOrDefault(i => i.FileID == itemId); context.ContentFiles.DeleteObject(I); context.SaveChanges(); } _data = null; }
public void CreateItem(string name, string path, string mimeType, bool isDirectory, long size, byte[] content) { int parentId = GetItemId(path); if (parentId < 0) { return; } using (EntitiesContext context = new EntitiesContext()) { ContentFile I = new ContentFile { Name = name, ParentID = parentId, MimeType = mimeType, IsDirectory = isDirectory, Size = int.Parse(size.ToString()), FileContent = content, PortalID = this.PortalID }; context.ContentFiles.AddObject(I); context.SaveChanges(); } _data = null; }
public static void InsertResponse(string ResponseIN) { if (ConfigurationManager.AppSettings.Get("PayPalSubmitUrl") != null) { try { string Environment = null; if (ConfigurationManager.AppSettings.Get("PayPalSubmitUrl") == "https://www.sandbox.paypal.com/cgi-bin/webscr") { Environment = "PayPalSandBox"; } if (ConfigurationManager.AppSettings.Get("PayPalSubmitUrl") == "https://www.paypal.com/cgi-bin/webscr") { Environment = "PayPalProduction"; } using (EntitiesContext context = new EntitiesContext()) { DAL.IPN I = new DAL.IPN { CreateDate = DateTime.Now, Environment = Environment, ResponseIN = ResponseIN }; context.IPNs.AddObject(I); context.SaveChanges(); ParseResponse(ResponseIN, I.IPNID); } } catch (Exception ex) { ElmahExtension.LogToElmah(ex); } } else { ElmahExtension.LogToElmah(new ApplicationException("Unable to read the value PayPalSubmitUrl in web.config file")); } }
public static void ParseResponse(string ResponseIN, int IPNID) { NameValueCollection PayPal_Args = HttpUtility.ParseQueryString(ResponseIN); using (EntitiesContext context = new EntitiesContext()) { var i = context.IPNs.FirstOrDefault(s => s.IPNID == IPNID); if (i != null) { if (PayPal_Args["txn_id"] != null) { i.txn_id = PayPal_Args["txn_id"]; } if (PayPal_Args["mc_gross"] != null) { i.mc_gross = decimal.Parse(PayPal_Args["mc_gross"]); } if (PayPal_Args["tax"] != null) { i.tax = decimal.Parse(PayPal_Args["tax"]); } if (PayPal_Args["protection_eligibility"] != null) { i.protection_eligibility = PayPal_Args["protection_eligibility"]; } if (PayPal_Args["address_status"] != null) { i.address_status = PayPal_Args["address_status"]; } if (PayPal_Args["payer_id"] != null) { i.payer_id = PayPal_Args["payer_id"]; } if (PayPal_Args["first_name"] != null) { i.first_name = PayPal_Args["first_name"]; } if (PayPal_Args["last_name"] != null) { i.last_name = PayPal_Args["last_name"]; } if (PayPal_Args["address_street"] != null) { i.address_street = PayPal_Args["address_street"]; } if (PayPal_Args["payment_date"] != null) { i.payment_date = PayPal_Args["payment_date"]; } if (PayPal_Args["payment_status"] != null) { i.payment_status = PayPal_Args["payment_status"]; } if (PayPal_Args["charset"] != null) { i.charset = PayPal_Args["charset"]; } if (PayPal_Args["address_zip"] != null) { i.address_zip = int.Parse(PayPal_Args["address_zip"]); } if (PayPal_Args["mc_fee"] != null) { i.mc_fee = decimal.Parse(PayPal_Args["mc_fee"]); } if (PayPal_Args["address_country_code"] != null) { i.address_country_code = PayPal_Args["address_country_code"]; } if (PayPal_Args["address_name"] != null) { i.address_name = PayPal_Args["address_name"]; } if (PayPal_Args["notify_version"] != null) { i.notify_version = decimal.Parse(PayPal_Args["notify_version"]); } if (PayPal_Args["custom"] != null) { i.custom = PayPal_Args["custom"]; } if (PayPal_Args["payer_status"] != null) { i.payer_status = PayPal_Args["payer_status"]; } if (PayPal_Args["business"] != null) { i.business = PayPal_Args["business"]; } if (PayPal_Args["address_country"] != null) { i.address_country = PayPal_Args["address_country"]; } if (PayPal_Args["address_city"] != null) { i.address_city = PayPal_Args["address_city"]; } if (PayPal_Args["quantity"] != null) { i.quantity = int.Parse(PayPal_Args["quantity"]); } if (PayPal_Args["verify_sign"] != null) { i.verify_sign = PayPal_Args["verify_sign"]; } if (PayPal_Args["payer_email"] != null) { i.payer_email = PayPal_Args["payer_email"]; } if (PayPal_Args["payment_type"] != null) { i.payment_type = PayPal_Args["payment_type"]; } if (PayPal_Args["address_state"] != null) { i.address_state = PayPal_Args["address_state"]; } if (PayPal_Args["receiver_email"] != null) { i.receiver_email = PayPal_Args["receiver_email"]; } if (PayPal_Args["payment_fee"] != null) { i.payment_fee = decimal.Parse(PayPal_Args["payment_fee"]); } if (PayPal_Args["receiver_id"] != null) { i.receiver_id = PayPal_Args["receiver_id"]; } if (PayPal_Args["txn_type"] != null) { i.txn_type = PayPal_Args["txn_type"]; } if (PayPal_Args["item_name"] != null) { i.item_name = PayPal_Args["item_name"]; } if (PayPal_Args["mc_currency"] != null) { i.mc_currency = PayPal_Args["mc_currency"]; } if (PayPal_Args["item_number"] != null) { i.item_number = PayPal_Args["item_number"]; } if (PayPal_Args["residence_country"] != null) { i.residence_country = PayPal_Args["residence_country"]; } if (PayPal_Args["test_ipn"] != null) { i.test_ipn = PayPal_Args["test_ipn"]; } if (PayPal_Args["handling_amount"] != null) { i.handling_amount = decimal.Parse(PayPal_Args["handling_amount"]); } if (PayPal_Args["transaction_subject"] != null) { i.transaction_subject = PayPal_Args["transaction_subject"]; } if (PayPal_Args["payment_gross"] != null) { i.payment_gross = decimal.Parse(PayPal_Args["payment_gross"]); } if (PayPal_Args["shipping"] != null) { i.shipping = decimal.Parse(PayPal_Args["shipping"]); } if (PayPal_Args["ipn_track_id"] != null) { i.ipn_track_id = PayPal_Args["ipn_track_id"]; } try { i.LastUpdated = DateTime.Now; i.ResponseParsed = true; context.SaveChanges(); } catch (Exception ex) { i.ResponseParsed = false; context.SaveChanges(); ElmahExtension.LogToElmah(ex); } } } }
public static void InsertResult(int _QuestionID, int _AnswerID, int _UserID, string _AnswerText, int _ResultID) { using (EntitiesContext context = new EntitiesContext()) { SurveyResultItem r = new SurveyResultItem { ResultID = _ResultID, QuestionID = _QuestionID, AnswerID = _AnswerID, UserID = _UserID, AnswerText = _AnswerText, PortalID = ResultItems.PortalID }; context.SurveyResultItems.AddObject(r); context.SaveChanges(); } }
/// <summary> /// Updates a PortalAlias entity by its entiy key using a hashtable of values. /// </summary> /// <param name="entityKey">The entity key of the PortalAlias entity</param> /// <param name="values">A hashtable of values</param> public static void Update(int entityKey, Hashtable values) { using (var context = new EntitiesContext()) { DAL.PortalAlia r = context.PortalAlias.Single(p => p.PortalAliasID == entityKey); r.PortalID = int.Parse(values["PortalID"].ToString()); r.HTTPAlias = values["HTTPAlias"].ToString(); r.LastUpdated = DateTime.Now; r.LastModifiedByUserID = (int)HttpContext.Current.Session["UserID"]; context.SaveChanges(); } }
/// <summary> /// Uses a hashtable of values to create and insert a new PortalAlias entity into the database /// </summary> /// <param name="values">The hashtable</param> public static void Insert(Hashtable values) { using (var context = new EntitiesContext()) { DAL.PortalAlia r = new DAL.PortalAlia { CreateDate = DateTime.Now, PortalID = int.Parse(values["PortalID"].ToString()), HTTPAlias = values["HTTPAlias"].ToString(), LastModifiedByUserID = (Int32)HttpContext.Current.Session["UserID"] }; context.AddToPortalAlias(r); context.SaveChanges(); } }