public int SetPirce(PriceOfMeal priceOfMeal)
{
DateTime currentDate = BdTime.GetCurrentDate();
string sql = "INSERT INTO [PriceOfMeal]" +
" (PricePerMeal,DateOfUpdate,TimeOfUpdate,UserId)" +
" VALUES(@pricePerMeal,@date,@time,@userId)";
Command = new SqlCommand(sql, Connection);
Command.Parameters.AddWithValue("@pricePerMeal", priceOfMeal.PricePerMeal);
Command.Parameters.AddWithValue("@userId", priceOfMeal.UserId);
Command.Parameters.AddWithValue("@date", currentDate.ToString("yyyy-MM-dd"));
Command.Parameters.AddWithValue("@time", currentDate.ToString("HH:mm:ss"));
Connection.Open();
int rowEffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowEffected);
}
public List <Transaction> MakeTransactionListByTotalMealOrderAndMonth(List <Order> listOfOrder, int operatedByUserId, int month, int year)
{
List <Transaction> listOfTransaction = new List <Transaction>();
DateTime currentTime = BdTime.GetCurrentDate();
ExpenseManager expenseManager = new ExpenseManager();
double currentMealPrice = expenseManager.GetAverageMealPriceOfMonth(month, year);
foreach (Order order in listOfOrder)
{
Transaction newTransaction = new Transaction();
newTransaction.OperatedByUserId = operatedByUserId;
newTransaction.OperatedToUserId = order.UserId;
newTransaction.Amount = currentMealPrice * (order.Meal1 + order.Meal2 + order.Meal3);
newTransaction.Date = currentTime.ToString("yyyy-MM-dd");
newTransaction.Time = currentTime.ToString("mm:hh ttt");
newTransaction.TransactionType = Transaction.remove;
listOfTransaction.Add(newTransaction);
}
return(listOfTransaction);
}
public int AddTransaction(Transaction transaction)
{
int rowEffected = 0;
DateTime currentDate = BdTime.GetCurrentDate();
string sql = "INSERT INTO [Transaction] " +
"(OperatedBy,OperatedTo,Amount,Date,Time,TransactionType) " +
"VALUES(@operatedBy,@operatedTo,@amount,@date,@time,@transactionType)";
Command = new SqlCommand(sql, Connection);
Command.Parameters.AddWithValue("@operatedBy", transaction.OperatedByUserId);
Command.Parameters.AddWithValue("@operatedTo", transaction.OperatedToUserId);
Command.Parameters.AddWithValue("@amount", transaction.Amount);
Command.Parameters.AddWithValue("@transactionType", transaction.TransactionType);
Command.Parameters.AddWithValue("@date", currentDate.ToString("yyyy-MM-dd"));
Command.Parameters.AddWithValue("@time", currentDate.ToString("HH:mm:ss"));
Connection.Open();
rowEffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowEffected);
}
public ActionResult AllExpenseOfMonth()
{
ExpenseManager expenseManager = new ExpenseManager();
DateTime currentTime = BdTime.GetCurrentDate();
ViewBag.AllExpenseOfMonth = expenseManager.GetListOfAllExpenseOfMonth(currentTime.Month, currentTime.Year);
return(View());
}
public ActionResult Info()
{
ExpenseManager expenseManager = new ExpenseManager();
DateTime currentTime = BdTime.GetCurrentDate();
double averageMealPriceOfMonth = expenseManager.GetAverageMealPriceOfMonth(currentTime.Month, currentTime.Year);
ViewBag.averageMealPriceOfMonth = Math.Round(averageMealPriceOfMonth, 3, MidpointRounding.ToEven);
return(View());
}
public int PutOrder(Order order)
{
/*
* [Id]
* ,[UserId]
* ,[Meal1]
* ,[Meal2]
* ,[Meal3]
* ,[Date]
* ,[Time]
* ,[Meal1Check]
* ,[Meal2Check]
* ,[Meal3Check]
*
* ,[PerMeal1Cost]
* ,[PerMeal2Cost]
* ,[PerMeal3Cost]
*/
DateTime currentDate = BdTime.GetCurrentDate();
string sql = "INSERT INTO OrderList " +
"(UserId,Meal1,Meal2,Meal3,Meal1Check,Meal2Check,Meal3Check,PerMeal1Cost,PerMeal2Cost,PerMeal3Cost,Date,Time) " +
" VALUES(@userId,@meal1,@meal2,@meal3,0,0,0,@perMeal1Cost,@perMeal2Cost,@perMeal3Cost,@date,@time)";
Command = new SqlCommand(sql, Connection);
Command.Parameters.AddWithValue("@userId", order.UserId);
Command.Parameters.AddWithValue("@meal1", order.Meal1);
Command.Parameters.AddWithValue("@meal2", order.Meal2);
Command.Parameters.AddWithValue("@meal3", order.Meal3);
Command.Parameters.AddWithValue("@date", currentDate.ToString("yyyy-MM-dd"));
Command.Parameters.AddWithValue("@time", currentDate.ToString("HH:mm:ss"));
Command.Parameters.AddWithValue("@perMeal1Cost", order.PerMeal1Cost);
Command.Parameters.AddWithValue("@perMeal2Cost", order.PerMeal2Cost);
Command.Parameters.AddWithValue("@perMeal3Cost", order.PerMeal3Cost);
Connection.Open();
int rowEffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowEffected);
}
public int AddDailyExpenses(Expense dailyExpense)
{
DateTime currentTime = BdTime.GetCurrentDate();
string sql = "INSERT INTO [Expenses] (Amount,UserId,Date,Time)" +
" VALUES(@amount,@userId,@date,@time)";
Command = new SqlCommand(sql, Connection);
Command.Parameters.AddWithValue("@amount", dailyExpense.Amount);
Command.Parameters.AddWithValue("@userId", dailyExpense.UserId);
Command.Parameters.AddWithValue("@date", currentTime.ToString("yyyy-MM-dd"));
Command.Parameters.AddWithValue("@time", currentTime.ToString("HH:mm:ss"));
Connection.Open();
int rowEffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowEffected);
}
public int SetTime(Time timeToSet)
{
DateTime currentDate = BdTime.GetCurrentDate();
string sql = "INSERT INTO [Time]" +
" (Time1Start,Time1End,Time2Start,Time2End," +
"Time3Start,Time3End,UserId,OrderDate,OrderTime) " +
"Values(@time1Start,@time1End,@time2Start,@time2End," +
"@time3Start,@time3End,@UserId,@date,@time)";
Command = new SqlCommand(sql, Connection);
Command.Parameters.AddWithValue("@time1Start", timeToSet.Time1Start);
Command.Parameters.AddWithValue("@time1End", timeToSet.Time1End);
Command.Parameters.AddWithValue("@time2Start", timeToSet.Time2Start);
Command.Parameters.AddWithValue("@time2End", timeToSet.Time2End);
Command.Parameters.AddWithValue("@time3Start", timeToSet.Time3Start);
Command.Parameters.AddWithValue("@date", currentDate.ToString("yyyy-MM-dd"));
Command.Parameters.AddWithValue("@time", currentDate.ToString("HH:mm:ss"));
Command.Parameters.AddWithValue("@time3End", timeToSet.Time3End);
Command.Parameters.AddWithValue("@UserId", timeToSet.UserId);
Connection.Open();
int rowEffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowEffected);
}
public void CalculateForDay()
{
UserManager userManager = new UserManager();
OrderManager orderManager = new OrderManager();
DateTime currentDate = BdTime.GetCurrentDate();
List <User> listOfActiveUser = userManager.GetLisOfActiveUser();
foreach (User user in listOfActiveUser)
{
if (orderManager.GetOrderByUseIdAndDate(user.Id, currentDate.ToString("yyyy-MM-dd")) == null)
{
Order newOrder = new Order();
newOrder.UserId = user.Id;
newOrder.Meal1 = .5;
newOrder.Meal2 = 1;
newOrder.Meal3 = 1;
orderManager.PutOrder(newOrder);
}
}
}
public void CalculateForMonth()
{
DateTime currentDate = BdTime.GetCurrentDate();
DateTime oneMonthBefore = currentDate.AddMonths(-1);
MonthCheckManager monthCheckManager = new MonthCheckManager();
OrderManager orderManager = new OrderManager();
ExpenseManager expenseManager = new ExpenseManager();
if (monthCheckManager.GetMonthCheckByMonthYear(oneMonthBefore.Month, oneMonthBefore.Year) == null)
{
TransactionManager transactionManager = new TransactionManager();
User currentUser = SetSession.GetCurrentUser();
List <Order> totalMealOfOrderList = orderManager.TotalMealForMonthByUserList(oneMonthBefore.Month, oneMonthBefore.Year);
List <Transaction> listOfTransaction =
transactionManager.MakeTransactionListByTotalMealOrderAndMonth
(totalMealOfOrderList, currentUser.Id, oneMonthBefore.Month, oneMonthBefore.Year);
transactionManager.MakeTransactionFromTransactionListForTotalCalculation(listOfTransaction);
double averageMealPriceOfMonth = expenseManager.GetAverageMealPriceOfMonth(oneMonthBefore.Month, oneMonthBefore.Year);
orderManager.AddMealPriceForAllOrderByMonth(oneMonthBefore.Month, oneMonthBefore.Year, averageMealPriceOfMonth);
monthCheckManager.AddCheckForMonthYear(oneMonthBefore.Month, oneMonthBefore.Year);
}
}
public int MakeTransactionForTotalCalculation(Transaction transaction)
{
DateTime currentDate = BdTime.GetCurrentDate();
int rowEffected = 0;
string sql = " INSERT INTO [Transaction] " +
"(OperatedBy,OperatedTo,Amount,Date,Time,TransactionType) " +
"VALUES(@operatedBy,@operatedTo,@amount,@date,@time,@transactionType)";
Command = new SqlCommand(sql, Connection);
Command.Parameters.AddWithValue("@operatedBy", transaction.OperatedByUserId);
Command.Parameters.AddWithValue("@operatedTo", transaction.OperatedToUserId);
Command.Parameters.AddWithValue("@amount", transaction.Amount);
Command.Parameters.AddWithValue("@transactionType", Transaction.remove);
Command.Parameters.AddWithValue("@date", currentDate.ToString("yyyy-MM-dd"));
Command.Parameters.AddWithValue("@time", currentDate.ToString("HH:mm:ss"));
Connection.Open();
rowEffected = Command.ExecuteNonQuery();
Connection.Close();
//UserManager userManager = new UserManager();
//userManager.RemoveBalanceByUserId(transaction.OperatedToUserId, Convert.ToInt32(transaction.Amount));
RemoveBalanceFromUserByTransaction(transaction);
return(rowEffected);
}
public static uint ToBdTimeValue(this TimeSpan span)
{
span.AssertNotNull();
return(BdTime.TicksToTimeValue(span.Ticks));
}
