public ViewDRJuice(StocksInventoryJuice sij, AccountOrderModel ao, List <FHJuiceProductModel> lstFprod)
{
stocksInventoryView = sij;
accountOrder = ao;
lstFHProducts = lstFprod;
InitializeComponent();
}
private void MenuViewDRConso_Click(object sender, RoutedEventArgs e)
{
AccountOrderModel am = dgvConsolidatedDR.SelectedItem as AccountOrderModel;
if (am != null)
{
lstFHProducts = getProductsOrderedConso(am.ID);
ViewDRJuice viewDR = new ViewDRJuice(this, am, lstFHProducts, true);
viewDR.ShowDialog();
}
}
private List <AccountOrderModel> loadConsolidatedDRS()
{
conDB = new ConnectionDB();
queryString = "SELECT dbjuiceacct.tblaccountorderconso.ID, drNo, clientID, dbjuiceacct.tblaccounts.accountname, " +
"deliverydate, terms, paymentduedate, total, repID, paymentmodeID, isPaid FROM (dbjuiceacct.tblaccountorderconso INNER JOIN " +
"dbjuiceacct.tblaccounts ON dbjuiceacct.tblaccountorderconso.clientID = dbjuiceacct.tblaccounts.ID) " +
"WHERE dbjuiceacct.tblaccountorderconso.isDeleted = 0 AND dbjuiceacct.tblaccounts.isDeleted = 0";
List <AccountOrderModel> lstDRs = new List <AccountOrderModel>();
AccountOrderModel drs = new AccountOrderModel();
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
while (reader.Read())
{
drs.ID = reader["ID"].ToString();
drs.DrNo = reader["drNo"].ToString();
drs.ClientName = reader["accountname"].ToString();
drs.ClientID = reader["clientID"].ToString();
DateTime pdate = DateTime.Parse(reader["deliverydate"].ToString());
drs.DeliveryDate = pdate.ToShortDateString();
pdate = DateTime.Parse(reader["paymentduedate"].ToString());
drs.PaymentDueDate = pdate.ToShortDateString();
drs.Terms = reader["terms"].ToString();
drs.Total = reader["total"].ToString();
drs.RepID = reader["repID"].ToString();
drs.isPaid = reader["isPaid"].ToString();
drs.PaymentModeID = reader["paymentmodeID"].ToString();
lstDRs.Add(drs);
drs = new AccountOrderModel();
}
conDB.closeConnection();
return(lstDRs);
}
public async Task <ActionResult> Order(int id)
{
AccountOrderModel model = new AccountOrderModel();
model.LoggedInUser = await userService.GetCurrentUser();
model.Order = model.LoggedInUser.Orders.SingleOrDefault(o => o.OrderID == id);
if (model.Order == null)
{
return(RedirectToAction("Orders"));
}
model.Order.ProductOrderEntries = model.Order.ProductOrderEntries.OrderBy(p => p.Listing.ListingName).ToList();
List <String> destNames = new List <String>()
{
ordersActionDest
};
model.FullNavList = CreateAccountControllerNavList(destNames);
return(View(model));
}
private List <AccountOrderModel> loadDREncoded()
{
conDB = new ConnectionDB();
queryString = "SELECT dbjuiceacct.tblaccountorder.ID, drNo, clientID, dbjuiceacct.tblaccounts.accountname, " +
"deliverydate, terms, paymentduedate, total, repID, paymentmodeID, isPaid FROM (dbjuiceacct.tblaccountorder INNER JOIN " +
"dbjuiceacct.tblaccounts ON dbjuiceacct.tblaccountorder.clientID = dbjuiceacct.tblaccounts.ID) " +
"WHERE dbjuiceacct.tblaccountorder.isDeleted = 0 AND dbjuiceacct.tblaccounts.isDeleted = 0 AND dbjuiceacct.tblaccountorder.isConso = 0";
List <AccountOrderModel> lstDRs = new List <AccountOrderModel>();
AccountOrderModel drs = new AccountOrderModel();
//parameters = new List<string>();
// DateTime dteNow = DateTime.Now;
//DateTime dteFirstDay = new DateTime(dteNow.Year, dteNow.Month, 1);
// parameters.Add(dteFirstDay.Year + "-" + dteFirstDay.Month + "-" + 1);
//parameters.Add(dteNow.Year + "-" + dteNow.Month + "-" + dteNow.Day);
//dateFrom.Text = dteFirstDay.ToShortDateString();
// dateTo.Text = dteNow.ToShortDateString();
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
while (reader.Read())
{
drs.ID = reader["ID"].ToString();
drs.DrNo = reader["drNo"].ToString();
drs.ClientName = reader["accountname"].ToString();
drs.ClientID = reader["clientID"].ToString();
DateTime pdate = DateTime.Parse(reader["deliverydate"].ToString());
drs.DeliveryDate = pdate.ToShortDateString();
pdate = DateTime.Parse(reader["paymentduedate"].ToString());
drs.PaymentDueDate = pdate.ToShortDateString();
drs.Terms = reader["terms"].ToString();
drs.Total = reader["total"].ToString();
drs.RepID = reader["repID"].ToString();
drs.isPaid = reader["isPaid"].ToString();
drs.PaymentModeID = reader["paymentmodeID"].ToString();
lstDRs.Add(drs);
drs = new AccountOrderModel();
}
conDB.closeConnection();
//lstDRCounts = getDRCountOnClients(dteFirstDay.Year + "-" + dteFirstDay.Month + "-" + 1,
// dteNow.Year + "-" + dteNow.Month + "-" + dteNow.Day);
//foreach (ClientModel cc in lstClients)
//{
// foreach (ClientModel drCC in lstDRCounts)
// {
// if (cc.ClientID.Equals(drCC.ClientID))
// {
// cc.DRCount = drCC.DRCount;
// }
// }
//}
return(lstDRs);
}
