// GET: Home
public ActionResult Index()
{
ActionResult result = checkUser();
if (result != null)
{
return(result);
}
BadgesModelView bmv = new BadgesModelView();
bmv.addNewBadge(74, CLIENT_ID); //Give user inital load of app badge if they havent earned it.
indexModelView mv = new indexModelView();
mv.savingsGoals = getSavingGoals();
mv.budgetGoals = getBudgetInfo();
mv.transactions = getTransactionInfo();
mv.badges = getAllBadges();
mv.clientBadges = getClientBadges();
decimal[] totals = getTotalIncomeAndSpent();
mv.totalIncome = totals[0];
mv.totalSpent = totals[1];
badgeTriggers();
return(View(mv));
}
// GET: AdministratorStockpile
public ActionResult Index()
{
PDBC db = new PDBC();
db.Connect();
indexModelView model = new indexModelView()
{
Table = new List <indexTableModel>()
};
using (DataTable dt = db.Select("SELECT [id_MPC] ,[code_Stockpile] ,[Title] ,[shop_name] ,[shop_IsAvailable] ,[shop_IsDelete] ,[MoneyTypeName] ,[PQT_Demansion] FROM [v_Stockpile_MainView]"))
{
int dtrowscount = dt.Rows.Count;
indexTableModel tableModel;
for (int i = 0; i < dtrowscount; i++)
{
tableModel = new indexTableModel();
using (DataTable dtSadere = db.Select("SELECT SUM([PriceOf_Transaction]) AS [SaderePriceOf_Transaction] ,SUM([PQTValueOf_Transaction]) AS [SaderePQTValueOf_Transaction] FROM [v_Stockpile_Transactions] WHERE [id_MPC] = " + dt.Rows[i]["id_MPC"].ToString() + " AND [id_TransactionType] =2"))
{
using (DataTable dtVarede = db.Select("SELECT SUM([PriceOf_Transaction]) AS [VaredePriceOf_Transaction] ,SUM([PQTValueOf_Transaction]) AS [VaredePQTValueOf_Transaction] FROM [v_Stockpile_Transactions] WHERE [id_MPC] = " + dt.Rows[i]["id_MPC"].ToString() + " AND [id_TransactionType] =1"))
{
if (dtVarede.Rows[0]["VaredePriceOf_Transaction"] != null && !string.IsNullOrEmpty(dtVarede.Rows[0]["VaredePriceOf_Transaction"].ToString()) && !string.IsNullOrEmpty(dtVarede.Rows[0]["VaredePQTValueOf_Transaction"].ToString()) && dtVarede.Rows[0]["VaredePQTValueOf_Transaction"] != null)
{
tableModel.AllEnteredPrice = String.Format("{0:n0}", dtVarede.Rows[0]["VaredePriceOf_Transaction"].ToString());
tableModel.AllEnteredValue = String.Format("{0:n0}", dtVarede.Rows[0]["VaredePQTValueOf_Transaction"].ToString());
}
else
{
tableModel.AllEnteredPrice = "0 " + dt.Rows[i]["MoneyTypeName"].ToString();
tableModel.AllEnteredValue = "0 " + dt.Rows[i]["PQT_Demansion"].ToString();
}
if (!string.IsNullOrEmpty(dtSadere.Rows[0]["SaderePriceOf_Transaction"].ToString()) && !string.IsNullOrEmpty(dtSadere.Rows[0]["SaderePQTValueOf_Transaction"].ToString()) && dtSadere.Rows[0]["SaderePriceOf_Transaction"] != null && dtSadere.Rows[0]["SaderePQTValueOf_Transaction"] != null)
{
tableModel.AllOutPriece = String.Format("{0:n0}", dtSadere.Rows[0]["SaderePriceOf_Transaction"].ToString());
tableModel.AllOutValue = String.Format("{0:n0}", dtSadere.Rows[0]["SaderePQTValueOf_Transaction"].ToString());
}
else
{
tableModel.AllOutPriece = "0 " + dt.Rows[i]["MoneyTypeName"].ToString();
tableModel.AllOutValue = "0 " + dt.Rows[i]["PQT_Demansion"].ToString();
}
}
}
if (i != 0 && i % 15 == 0)
{
db.DC();
db.Connect();
}
tableModel.ProductName = dt.Rows[i]["Title"].ToString();
tableModel.rowNumber = i + 1;
tableModel.Shopname = dt.Rows[i]["shop_name"].ToString();
tableModel.ProductDimension = dt.Rows[i]["PQT_Demansion"].ToString();
tableModel.ProductCode = dt.Rows[i]["code_Stockpile"].ToString();
tableModel.id_MPC = dt.Rows[i]["id_MPC"].ToString();
model.Table.Add(tableModel);
}
db.DC();
}
return(View(model));
}
