public ActionResult Create(Product product, HttpPostedFileBase file) { long?UserID = Convert.ToInt64(User.Identity.Name); if (ModelState.IsValid) { string pic = ""; if (file != null) { if (file.ContentLength != 0) { pic = System.IO.Path.GetFileName(file.FileName); pic = Guid.NewGuid() + "_" + pic; string path = System.IO.Path.Combine(Server.MapPath("~/Content/upload/" + UserID + "/Commerce"), pic); // file is uploaded file.SaveAs(path); // product.ProductImage = "Content/upload/" + UserID + "/Commerce/" + pic; product.ProductImage = "/xImage/" + UserID + "/Commerce/" + pic; UserUsage userUsage = db.UserUsages.FirstOrDefault(x => x.UserID == UserID); userUsage.UsedStorage += Mathmatics.ConvertBytesToMegabytes(file.ContentLength); db.SaveChanges(); } } product.UserID = UserID; db.Products.Add(product); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CatagoryID = new SelectList(db.ProductCatagories.Where(x => x.UserID == UserID), "Id", "CatagoryName"); return(View(product)); }
public ActionResult DeleteFile(int?Id) { using (var tran = db.Database.BeginTransaction()) { try { string filePath = null; long? UserID = Convert.ToInt64(User.Identity.Name); FileCollection fileCol = db.FileCollections.FirstOrDefault(x => x.Id == Id && x.UserID == UserID); filePath = Server.MapPath("~/" + fileCol.FilePath); db.FileCollections.Remove(fileCol); db.SaveChanges(); if (!string.IsNullOrEmpty(filePath)) { if (System.IO.File.Exists(filePath)) { long length = new System.IO.FileInfo(filePath).Length; System.IO.File.Delete(filePath); UserUsage userUsage = db.UserUsages.FirstOrDefault(x => x.UserID == UserID); userUsage.UsedStorage = userUsage.UsedStorage - Mathmatics.ConvertBytesToMegabytes(length); db.SaveChanges(); } } tran.Commit(); } catch (Exception er) { tran.Rollback(); } } return(RedirectToAction("UploadImage")); }
public ActionResult UploadImage(HttpPostedFileBase file) { string pic = ""; var UserID = Convert.ToInt64(User.Identity.Name); using (var trans = db.Database.BeginTransaction()) { try { if (file != null) { if (file.ContentLength != 0) { FileCollection fileCol = new FileCollection(); if (!System.IO.Directory.Exists(Server.MapPath("~/Content/upload"))) { System.IO.Directory.CreateDirectory(Server.MapPath("~/Content/upload")); } pic = System.IO.Path.GetFileName(file.FileName); string picExtention = System.IO.Path.GetExtension(pic); pic = Guid.NewGuid() + "_a" + picExtention; string path = System.IO.Path.Combine(Server.MapPath("~/Content/upload/" + UserID), pic); // file uploading file.SaveAs(path); // string filePath = "http://" + Request.ServerVariables["HTTP_HOST"] + "/Content/filecollection/" + pic; string filePath = "Content/upload/" + UserID + "/" + pic; fileCol.FilePath = filePath; fileCol.UserID = UserID; db.FileCollections.Add(fileCol); db.SaveChanges(); UserUsage userUsage = db.UserUsages.FirstOrDefault(x => x.UserID == UserID); userUsage.UsedStorage += Mathmatics.ConvertBytesToMegabytes(file.ContentLength); db.SaveChanges(); trans.Commit(); TempData["Msg"] = "<h2 class='text-center' style='display: block; color: green'>File has been uploaded</h2><p><b>Link to Copy: </b> " + filePath + "</p>"; return(RedirectToAction("UploadImage")); } else { TempData["Msg"] = "<h2 class='text-center' style='display: block; color: green'>File not uploaded. Please try agian</h2>"; return(RedirectToAction("UploadImage")); } } } catch (Exception er) { trans.Rollback(); } } TempData["Msg"] = "<h2 class='text-center' style='display: block; color: green'>There is an error please try again.</h2>"; return(RedirectToAction("UploadImage")); }
public object Get(UserGetUsageRequestTep request) { List <KeyValuePair <string, string> > result = new List <KeyValuePair <string, string> >(); var context = TepWebContext.GetWebContext(PagePrivileges.UserView); try { context.Open(); context.LogInfo(this, string.Format("/user/{{id}}/usage GET id='{0}'", request.Id)); var user = (request.Id != 0 ? User.FromId(context, request.Id) : User.FromUsername(context, request.Identifier)); UserUsage usu = new UserUsage(context, user.Id); //global usage result.Add(new KeyValuePair <string, string>("overall", "" + usu.GetScore())); //data package usage List <Type> types = new List <Type>(); types.Add(typeof(DataPackage)); types.Add(typeof(RemoteResource)); types.Add(typeof(RemoteResourceSet)); result.Add(new KeyValuePair <string, string>("data/package", "" + usu.GetScore(types))); //wps job usage types = new List <Type>(); types.Add(typeof(WpsJob)); result.Add(new KeyValuePair <string, string>("job/wps", "" + usu.GetScore(types))); //wps service usage types = new List <Type>(); types.Add(typeof(Terradue.Portal.Service)); types.Add(typeof(WpsProcessOffering)); result.Add(new KeyValuePair <string, string>("service/wps", "" + usu.GetScore(types))); context.LogDebug(this, string.Format("Get User '{0}' usage", User.FromId(context, usu.UserId).Username)); context.Close(); } catch (Exception e) { context.LogError(this, e.Message, e); context.Close(); throw e; } return(result); }
public ActionResult Edit(User user, HttpPostedFileBase file) { if (ModelState.IsValid) { using (var trasn = db.Database.BeginTransaction()) { try { long? UserID = Convert.ToInt64(User.Identity.Name); User detail = db.Users.Find(UserID); string OldPicPath = detail.ProfilePic; string pic = ""; if (file != null) { if (file.ContentLength != 0) { pic = System.IO.Path.GetFileName(file.FileName); pic = Guid.NewGuid() + "_" + pic; string path = System.IO.Path.Combine(Server.MapPath("~/Content/upload/" + UserID), pic); // file is uploaded file.SaveAs(path); detail.ProfilePic = "Content/upload/" + UserID + "/" + pic; UserUsage userUsage = db.UserUsages.FirstOrDefault(x => x.UserID == UserID); userUsage.UsedStorage += Mathmatics.ConvertBytesToMegabytes(file.ContentLength); db.SaveChanges(); } } detail.FirstName = user.FirstName; detail.LastName = user.LastName; detail.Email = user.Email; detail.Address = user.Address; detail.CellNumber = user.CellNumber; detail.Password = user.Password; db.SaveChanges(); Session["UserProfilePath"] = detail.ProfilePic; Session["UserFirstName"] = !string.IsNullOrEmpty(detail.FirstName) ? detail.FirstName.ToUpper() : "Hi!"; if (!string.IsNullOrEmpty(OldPicPath)) { string fileToDelete = Server.MapPath("~/" + OldPicPath); if (!string.IsNullOrEmpty(fileToDelete)) { if (System.IO.File.Exists(fileToDelete)) { long length = new System.IO.FileInfo(fileToDelete).Length; System.IO.File.Delete(fileToDelete); UserUsage PriHistory = db.UserUsages.FirstOrDefault(x => x.UserID == UserID); PriHistory.UsedStorage = PriHistory.UsedStorage - Mathmatics.ConvertBytesToMegabytes(length); db.SaveChanges(); } } } trasn.Commit(); return(RedirectToAction("Index")); } catch (Exception er) { trasn.Rollback(); } } } return(View(user)); }
public async Task <ActionResult> Edit(ShopUser shopUser, HttpPostedFileBase file) { using (var Tran = db.Database.BeginTransaction()) { try { // validate current sub domain domainIndentifier = new DomainIdentifier(Request.Url.Host, Request.ServerVariables["SERVER_NAME"]); var User = domainIndentifier.GetUserRelatedDomain(); UserID = User != null ? User.Id : 0; ViewBag.UserID = UserID; Session["CurrentUserID"] = UserID; //// check user is login or not if (string.IsNullOrEmpty(Convert.ToString(Session["WebloggedUserID"]))) { return(Redirect("/Account/Login")); } // bussiness logic long ShopUserID = Convert.ToInt64(Session["WebloggedUserID"]); ViewBag.ShopUserID = ShopUserID; if (ModelState.IsValid) { ShopUser Customer = db.ShopUsers.FirstOrDefault(x => x.Id == ShopUserID); if (!System.IO.Directory.Exists(Server.MapPath("~/Content/upload/" + UserID + "/Commerce"))) { System.IO.Directory.CreateDirectory(Server.MapPath("~/Content/upload/" + UserID + "/ShopUsers")); } if (file != null) { if (file.ContentLength > 0) { string FileExtention = Path.GetExtension(file.FileName); string FileName = Guid.NewGuid().ToString() + DateTime.Now.ToString("yyyydd") + ShopUserID + FileExtention; string FileSavePath = System.IO.Path.Combine(Server.MapPath("~/Content/upload/" + UserID + "/ShopUsers"), FileName); file.SaveAs(FileSavePath); Customer.ProfileImagePath = "Content/upload/" + UserID + "/ShopUsers" + FileName; } } int IsSavedIntoStorageTable = 0; string PreProfilePath = Customer.ProfileImagePath; Customer.CurrentAddress = shopUser.CurrentAddress; Customer.DisplayName = shopUser.DisplayName; Customer.Email = shopUser.Email; Customer.FirstName = shopUser.FirstName; Customer.LastName = shopUser.LastName; Customer.Mobile = shopUser.Mobile; Customer.Password = shopUser.Password; Customer.PermanentAddress = shopUser.PermanentAddress; Customer.Phone = shopUser.Phone; Customer.SecPhone = shopUser.SecPhone; int isSavedIntoShopUser = await db.SaveChangesAsync(); // Insert Data if (!string.IsNullOrEmpty(PreProfilePath)) { string fileToDelete = Server.MapPath("~/" + PreProfilePath); if (!string.IsNullOrEmpty(fileToDelete)) { if (System.IO.File.Exists(fileToDelete)) { long length = new System.IO.FileInfo(fileToDelete).Length; UserUsage PriHistory = db.UserUsages.FirstOrDefault(x => x.UserID == UserID); PriHistory.UsedStorage = PriHistory.UsedStorage - Mathmatics.ConvertBytesToMegabytes(length); IsSavedIntoStorageTable = db.SaveChanges(); // Insert Data System.IO.File.Delete(fileToDelete); } } } if (isSavedIntoShopUser > 0 && IsSavedIntoStorageTable > 0) { Tran.Commit(); return(RedirectToAction("Detail")); } return(View(shopUser)); } } catch (Exception er) { Tran.Rollback(); } return(View(shopUser)); } }
public ActionResult Edit(SiteSetting siteSetting, HttpPostedFileBase file) { using (var Transaction = db.Database.BeginTransaction()) { long?UserID = Convert.ToInt64(User.Identity.Name); var setting = db.SiteSettings.FirstOrDefault(x => x.UserID == UserID); try { if (ModelState.IsValid) { string OldLogoPath = setting.Logo; string pic = ""; if (file != null) { if (file.ContentLength != 0) { pic = System.IO.Path.GetFileName(file.FileName); pic = Guid.NewGuid() + "_" + pic; string path = System.IO.Path.Combine(Server.MapPath("~/Content/upload/" + UserID), pic); // file is uploaded file.SaveAs(path); setting.Logo = "Content/upload/" + UserID + "/" + pic; UserUsage userUsage = db.UserUsages.FirstOrDefault(x => x.UserID == UserID); userUsage.UsedStorage += Mathmatics.ConvertBytesToMegabytes(file.ContentLength); db.SaveChanges(); } } setting.Email = siteSetting.Email; setting.OfficeAddress = siteSetting.OfficeAddress; setting.Phone = siteSetting.Phone; setting.SmtpEmail = siteSetting.SmtpEmail; setting.SmtpIsEnableSSL = siteSetting.SmtpIsEnableSSL; setting.SmtpPassword = siteSetting.SmtpPassword; setting.SmtpPort = siteSetting.SmtpPort; setting.SmtpServer = siteSetting.SmtpServer; db.SaveChanges(); if (!string.IsNullOrEmpty(OldLogoPath)) { string fileToDelete = Server.MapPath("~/" + OldLogoPath); if (!string.IsNullOrEmpty(fileToDelete)) { if (System.IO.File.Exists(fileToDelete)) { long length = new System.IO.FileInfo(fileToDelete).Length; UserUsage PriHistory = db.UserUsages.FirstOrDefault(x => x.UserID == UserID); PriHistory.UsedStorage = PriHistory.UsedStorage - Mathmatics.ConvertBytesToMegabytes(length); db.SaveChanges(); System.IO.File.Delete(fileToDelete); } } } Transaction.Commit(); return(RedirectToAction("Index")); } } catch (Exception er) { Transaction.Rollback(); } return(View(setting)); } }
public List <Ingredient> GetRecipe(long id) { //HttpRequest currentRequest = HttpContext.Request.; //HttpRequest currentRequest = HttpContext.Current.Request; //String clientIP = currentRequest.ServerVariables["REMOTE_ADDR"]; String ipAddress = System.Web.HttpContext.Current.Request.UserHostAddress; UserUsage myUser = new UserUsage { dateTimeUpdate = DateTime.Now, CocktailId = id, Address = ipAddress }; List <Ingredient> MyIngredients = new List <Ingredient>(); var Mliquor = (from c in db.CocktailLiquors where c.CocktailId == id select new { c.Amount, c.Liquor.Name, c.Id, c.CocktailId }).ToList(); var MnoAlcohols = (from b in db.CocktailNoAlcohols where b.CocktailId == id select new { b.Amount, b.NoAlcohol.Name, b.Id, b.CocktailId }).ToList(); var Mcordials = (from a in db.CocktailCordials where a.CocktailId == id select new { a.Amount, a.Cordial.Name, a.Id, a.CocktailId }).ToList(); //var Mgarnishes = db.Garnishes.Select(g => g.CockTails.Select(co => co.CocktailId == id)).ToList(); //var Mgarnishes = (from d in db.Garnishes select d.CockTails.Select(s=>s.CocktailId==id)).ToList(); //var Mgarnishes = (from d in db.Garnishes.ToList() let Amount =(float)1.0 where d.CockTails.Where == id select new {d.Name,d. }).ToList(); var Mgarnishes = (from d in db.Garnishes from e in d.CockTails where e.CocktailId == id select new { d.Name, d.Id, id }).ToList(); var Mprocesses = (from d in db.Processes from e in d.CockTails where e.CocktailId == id select new { d.Name, d.Id, id }).ToList(); var Mglass = (from gl in db.CockTails where gl.CocktailId == id select gl.Glass).Single(); var Mcategory = (from ct in db.CockTails where ct.CocktailId == id select ct.Category).Single(); //var Mprocess = (from p in db.CockTails where p.CocktailId == id select p.Process).Single(); foreach (var ing in Mliquor) { MyIngredients.Add(new Ingredient { CocktailId = (int)ing.CocktailId, Id = ing.Id, Type = "L", Amount = ing.Amount, Name = ing.Name }); } foreach (var ing in MnoAlcohols) { MyIngredients.Add(new Ingredient { CocktailId = (int)ing.CocktailId, Id = ing.Id, Type = "N", Amount = ing.Amount, Name = ing.Name }); } foreach (var ing in Mcordials) { MyIngredients.Add(new Ingredient { CocktailId = (int)ing.CocktailId, Id = ing.Id, Type = "C", Amount = ing.Amount, Name = ing.Name }); } foreach (var ing in Mgarnishes) { // MyIngredients.Add(new Ingredient { CocktailId = (int)ing.CocktailId, Id = ing.Id, Type = "G", Amount = 1, Name = ing.Name }); MyIngredients.Add(new Ingredient { CocktailId = (int)id, Id = ing.Id, Type = "G", Amount = 1, Name = ing.Name }); } foreach (var ing in Mprocesses) { // MyIngredients.Add(new Ingredient { CocktailId = (int)ing.CocktailId, Id = ing.Id, Type = "G", Amount = 1, Name = ing.Name }); MyIngredients.Add(new Ingredient { CocktailId = (int)id, Id = ing.Id, Type = "P", Amount = 1, Name = ing.Name }); } MyIngredients.Add(new Ingredient { CocktailId = (int)id, Id = id, Type = "S", Amount = 1, Name = Mglass.Name }); // Here is adding a glass //MyIngredients.Add(new Ingredient { CocktailId = (int)id, Id = id, Type = "R", Amount = 1, Name = Mcategory.Name }); // Here is adding a the category //MyIngredients.Add(new Ingredient { CocktailId = (int)id, Id = id, Type = "P", Amount = 1, Name = Mprocess.Name }); db.UserUsages.Add(myUser); db.SaveChanges(); return(MyIngredients); }
public void Post(UserUsage usage) { var repo = new UsageRepository(); repo.Save(new UsageRow(usage)); }
public ActionResult Edit(Product productModel, HttpPostedFileBase file) { long?UserID = Convert.ToInt64(User.Identity.Name); var product = db.Products.FirstOrDefault(x => x.UserID == UserID && x.Id == productModel.Id); using (var Tran = db.Database.BeginTransaction()) { try { if (ModelState.IsValid) { string oldImage = product.ProductImage; string pic = ""; if (file != null) { if (file.ContentLength != 0) { pic = System.IO.Path.GetFileName(file.FileName); pic = Guid.NewGuid() + "_" + pic; string path = System.IO.Path.Combine(Server.MapPath("~/Content/upload/" + UserID + "/Commerce"), pic); // file is uploaded file.SaveAs(path); // product.ProductImage = "Content/upload/" + UserID + "/Commerce/" + pic; product.ProductImage = "/xImage/" + UserID + "/Commerce/" + pic; UserUsage userUsage = db.UserUsages.FirstOrDefault(x => x.UserID == UserID); userUsage.UsedStorage += Mathmatics.ConvertBytesToMegabytes(file.ContentLength); db.SaveChanges(); } } product.UserID = UserID; product.Name = productModel.Name; product.Description = productModel.Description; product.Discount = productModel.Discount; product.Price = productModel.Price; productModel.CatagoryID = productModel.CatagoryID; db.SaveChanges(); if (!string.IsNullOrEmpty(oldImage)) { string fileToDelete = Server.MapPath("~/" + oldImage); if (!string.IsNullOrEmpty(fileToDelete)) { if (System.IO.File.Exists(fileToDelete)) { long length = new System.IO.FileInfo(fileToDelete).Length; UserUsage PriHistory = db.UserUsages.FirstOrDefault(x => x.UserID == UserID); PriHistory.UsedStorage = PriHistory.UsedStorage - Mathmatics.ConvertBytesToMegabytes(length); db.SaveChanges(); System.IO.File.Delete(fileToDelete); } } } return(RedirectToAction("Index")); } Tran.Commit(); ViewBag.CatagoryID = new SelectList(db.ProductCatagories.Where(x => x.UserID == UserID), "Id", "CatagoryName"); } catch (Exception er) { Tran.Rollback(); } } return(View(product)); }
private decimal CalculateEmission(UserUsage usage, decimal oldEmission) { decimal finalEmission = 0; try { var rand = new Random(); var factor = 0.0; var averageUsage = 0.0; switch (usage.Product.Trim().ToUpper()) { case "BEDROOMS": factor = 0.27; averageUsage = 4; break; case "COMPUTER": factor = 0.19; averageUsage = 4; break; case "MOBILE PHONES": factor = 0.02; averageUsage = 4; break; case "TELEVISION": factor = 0.58; averageUsage = 8; break; case "MICROWAVE OVEN": factor = 0.945; averageUsage = 1; break; case "OVEN": factor = 1.56; averageUsage = 1; break; case "AIRCONDITIONER": factor = 1.25; averageUsage = 2.5; break; case "HEATER": factor = 1.11; averageUsage = 2.5; break; case "REFRIGERATOR": factor = 0.42; averageUsage = 24; break; case "FREEZER": factor = 0.56; averageUsage = 24; break; case "DISHWASHER": factor = 1.07; averageUsage = 1.5; break; case "DRYER": factor = 2.50; averageUsage = 1; break; case "WASHING MACHINE": factor = 0.63; averageUsage = 1; break; case "LIGHT BULB": factor = 0.08; averageUsage = 12; break; } usage.Emission = (decimal)(usage.Quantity * factor * averageUsage * 365); // update user emission var username = Context.User.Identity.GetUserId(); var user = _connections.Get(username); if (user != null) { user.Emission -= oldEmission; user.Emission += usage.Emission; finalEmission = user.Emission; _connections.Update(user); } } catch { } return(finalEmission); }
public void AddUsage(string product, int quantity) { try { decimal finalEmission = 0; var username = Context.User.Identity.GetUserId(); var ctx = ApplicationDbContext.Create(); var usage = ctx.UserUsages.FirstOrDefault( u => u.Username.Equals(username, StringComparison.InvariantCultureIgnoreCase) && u.Product.Equals(product, StringComparison.InvariantCultureIgnoreCase)); if (usage == null) { usage = new UserUsage { Username = username, Emission = 0, Product = product, Quantity = quantity }; finalEmission = CalculateEmission(usage, 0); ctx.UserUsages.Add(usage); } else { if (quantity <= 0) { finalEmission = RemoveUsage(usage.Id); } else { var oldEmission = usage.Emission; usage.Quantity = quantity; finalEmission = CalculateEmission(usage, oldEmission); } } var appUser = ctx.Users .FirstOrDefault(u => u.Id.ToString().Equals(username, StringComparison.InvariantCultureIgnoreCase)); if (appUser != null) { appUser.Emission = finalEmission; } ctx.SaveChanges(); } catch (Exception ex) { } finally { GetMyUsage(); UserListChanged(); } }