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);
}
}
