public IActionResult ShowUserProfile() { var users = _dataContext.Users.Include(x => x.Wallet).ThenInclude(y => y.Deals).ThenInclude(z => z.Stock).ThenInclude(t => t.Company); User currentUser = users.FirstOrDefault(p => p.UserName == User.Identity.Name); UserInfoViewModel model = new UserInfoViewModel { Id = currentUser.Id, UserName = currentUser.UserName, TotalMoneySum = currentUser.Wallet.TotalSum }; List <PurchasedStock> purchasedStocks = new List <PurchasedStock>(); foreach (var deal in currentUser.Wallet.Deals) { PurchasedStock purchasedStock = new PurchasedStock { StockId = deal.Stock.Id, CompanyFullName = deal.Stock.Company.FullName, CompanyShortName = deal.Stock.Company.ShortName, PurchasedStockNumber = deal.StockNumber, StockGrowth = deal.Stock.CurrentPrice - deal.CurrentStockPrice, StockGrowthInPercent = (deal.Stock.CurrentPrice - deal.CurrentStockPrice) / deal.Stock.CurrentPrice * 100 }; purchasedStocks.Add(purchasedStock); } foreach (var p in purchasedStocks) { PurchasedStock purchasedStock = new PurchasedStock { StockId = p.StockId, CompanyFullName = p.CompanyFullName, CompanyShortName = p.CompanyShortName, StockGrowth = p.StockGrowth, StockGrowthInPercent = p.StockGrowthInPercent, PurchasedStockNumber = 0 }; foreach (var t in purchasedStocks) { if (p.CompanyShortName == t.CompanyShortName) { purchasedStock.PurchasedStockNumber += t.PurchasedStockNumber; } } model.PurchasedStocks.Add(purchasedStock); } model.PurchasedStocks = model.PurchasedStocks.GroupBy(x => x.CompanyShortName).Select(x => x.First()).ToList(); foreach (var deal in currentUser.Wallet.Deals) { DealDetails dealDetails = new DealDetails { CompanyName = deal.Stock.Company.FullName, CompanyShortName = deal.Stock.Company.ShortName, IsBought = deal.IsBought, DealDate = deal.DealDate, StockNumberInDeal = deal.StockNumber }; model.DealsDetails.Add(dealDetails); } return(View(model)); }
/// <summary> /// fetch data from csv /// </summary> /// <param name="srCsv"></param> /// <returns>List of DealDetails from csv</returns> public List <DealDetails> GetDealDataFromCsv(StreamReader srCsv) { var lstDeal = new List <DealDetails>(); var firstRow = true; //skip header row while (!srCsv.EndOfStream) { var dealDetailRow = srCsv.ReadLine(); //skip header row if (firstRow) { firstRow = false; continue; } if (!string.IsNullOrEmpty(dealDetailRow)) { var dealDetail = StringUtility.SplitCsvRow(dealDetailRow); var deal = new DealDetails() { DealerNumber = StringUtility.GetInteger(dealDetail[0]), CustomerName = dealDetail[1], DealerShipName = dealDetail[2], Vehicle = dealDetail[3], Price = StringUtility.GetDecimal(dealDetail[4]), Date = StringUtility.GetDateTime(dealDetail[5]) }; lstDeal.Add(deal); } } return(lstDeal); }
public ActionResult DealPubOwnerDetails(int id = 0) { DealDetails dealDetails = _repository.Details(id); //if (dealDetails == null) //{ // return HttpNotFound(); //} return(View(dealDetails)); }
public static object SaveDealData(string hdnID, string Name, string NoOfPerson, string DaysOfWeek, string Dishs, string Description, string start_time1, string start_time2, string start_time3, string start_time4, string end_time1, string end_time2, string end_time3, string end_time4, string Discount1, string Discount2, string Discount3, string Discount4) { RestaurantDeal objmod = new RestaurantDeal(); objmod.Id = string.IsNullOrEmpty(hdnID) ? 0 : Int32.Parse(hdnID); objmod.RestaurantId = (HttpContext.Current.Session["LoggedIn_User"] as UserInfo).RestaurantDetails.ID; objmod.Name = Name; objmod.NoOfPerson = string.IsNullOrEmpty(NoOfPerson) ? 0 : Int32.Parse(NoOfPerson); objmod.DaysOfWeek = DaysOfWeek; objmod.Description = Description; //////Set deal Timings if (!string.IsNullOrEmpty(start_time1) && !string.IsNullOrEmpty(end_time1) && !string.IsNullOrEmpty(Discount1)) { DealDetails objDealDetails = new DealDetails(); objDealDetails.Discount = Int32.Parse(Discount1); objDealDetails.StartTime = start_time1; objDealDetails.EndTime = end_time1; objmod.SpecificDealDetails.Add(objDealDetails); } if (!string.IsNullOrEmpty(start_time2) && !string.IsNullOrEmpty(end_time2) && !string.IsNullOrEmpty(Discount2)) { DealDetails objDealDetails = new DealDetails(); objDealDetails.Discount = Int32.Parse(Discount2); objDealDetails.StartTime = start_time2; objDealDetails.EndTime = end_time2; objmod.SpecificDealDetails.Add(objDealDetails); } if (!string.IsNullOrEmpty(start_time3) && !string.IsNullOrEmpty(end_time3) && !string.IsNullOrEmpty(Discount3)) { DealDetails objDealDetails = new DealDetails(); objDealDetails.Discount = Int32.Parse(Discount3); objDealDetails.StartTime = start_time3; objDealDetails.EndTime = end_time3; objmod.SpecificDealDetails.Add(objDealDetails); } if (!string.IsNullOrEmpty(start_time4) && !string.IsNullOrEmpty(end_time4) && !string.IsNullOrEmpty(Discount4)) { DealDetails objDealDetails = new DealDetails(); objDealDetails.Discount = Int32.Parse(Discount4); objDealDetails.StartTime = start_time4; objDealDetails.EndTime = end_time4; objmod.SpecificDealDetails.Add(objDealDetails); } ///////Set Deal Dishes if (!string.IsNullOrEmpty(Dishs)) { string[] d_li = Dishs.Split(','); foreach (string d in d_li) { Dish objDish = new Dish(); objDish.Id = Int32.Parse(d); objmod.Dish_li.Add(objDish); } } ///Set Deal Images if (HttpContext.Current.Session["ImportFilesName"] != null) { //string CurrentFilePath = System.Web.HttpContext.Current.Server.MapPath(UtilityFunctions.ImportDocumentPath) + ((HttpContext.Current.Session["ImportFileName"] == null) ? "" : HttpContext.Current.Session["ImportFileName"].ToString()); string[] images_li = HttpContext.Current.Session["ImportFilesName"].ToString().Split(','); foreach (string img in images_li) { objmod.Img_path.Add(img); } } RestaurantsDAL objmodelDal = new RestaurantsDAL(); return(objmodelDal.SaveDealData(objmod, true)); }
public RestaurantDeal GetDeal_Details(int RestaurantID, int RestaurantDealID) { RestaurantDeal objRestaurantDeal = new RestaurantDeal(); ///Declare and Set paramiterized query String queryString = "GetRestaurantsDeals_Report @Mode,@RestaurantID,@RestaurantDealID"; ///Declare and Set paramiterized query using (SqlConnection connection = new SqlConnection(Connection_String)) { ///Set SQL Command SqlCommand command = new SqlCommand(queryString, connection); ///Set parameters for paramiterized query command.Parameters.Add("@Mode", System.Data.SqlDbType.Int).Value = 1; command.Parameters.Add("@RestaurantID", System.Data.SqlDbType.Int).Value = RestaurantID; command.Parameters.Add("@RestaurantDealID", System.Data.SqlDbType.Int).Value = RestaurantDealID; try { ///Open SQL Established connection connection.Open(); ///Execute SQL Command and store return result in a SQL Reader SqlDataReader dr = command.ExecuteReader(); ///Get Deal Dishes while (dr.Read()) { Dish objDish = new Dish(); objDish.Id = dr.IsDBNull(dr.GetOrdinal("DishID")) ? -1 : dr.GetInt32(dr.GetOrdinal("DishID")); objDish.Name = dr.IsDBNull(dr.GetOrdinal("Dish")) ? "" : dr.GetString(dr.GetOrdinal("Dish")); objRestaurantDeal.Dish_li.Add(objDish); } ///Get Deal Images if (dr.NextResult()) { while (dr.Read()) { string path = dr.IsDBNull(dr.GetOrdinal("ImagePath")) ? "" : dr.GetString(dr.GetOrdinal("ImagePath")); if (!string.IsNullOrEmpty(path)) { objRestaurantDeal.Img_path.Add(path); } } } if (dr.NextResult()) { while (dr.Read()) { objRestaurantDeal.QualityRating = dr.IsDBNull(dr.GetOrdinal("QualityRatting")) ? -1 : dr.GetInt32(dr.GetOrdinal("QualityRatting")); objRestaurantDeal.PriceRating = dr.IsDBNull(dr.GetOrdinal("PriceRating")) ? -1 : dr.GetInt32(dr.GetOrdinal("PriceRating")); } } ///Get Deal gernal details if (dr.NextResult()) { while (dr.Read()) { DealDetails objDealDetails = new DealDetails(); objDealDetails.StartTime = dr.IsDBNull(dr.GetOrdinal("DealTimeFrom")) ? "" : dr.GetTimeSpan(dr.GetOrdinal("DealTimeFrom")).ToString("hh\\:mm\\:ss"); objDealDetails.Discount = dr.IsDBNull(dr.GetOrdinal("Percentage")) ? -1 : dr.GetInt32(dr.GetOrdinal("Percentage")); objRestaurantDeal.SpecificDealDetails.Add(objDealDetails); } } } catch (Exception e) { } return(objRestaurantDeal); } }