public ActionResult Index(int?orderid)
{
Administrator admin = new Administrator();
DateTime date = System.DateTime.Now.Date;
DateTime date1 = date.AddDays(+7);
//--------------------------Medication ------------------------------
//#region
//var availablemedicinedose = AnimalInformationDBAcces.GetAvailableMedicinedose();
//if (availablemedicinedose!=null)
//{
// availablemedicinedose = availablemedicinedose.Where(a => a.MedicationDate >= date && a.MedicationDate <= date1).ToList();
//}
//List<MedicationList> lists = new List<MedicationList>();
//foreach (var medicineli in availablemedicinedose)
//{
// var animalcodename = AnimalInformationDBAcces.GetAnimalInfoByID(medicineli.medicine.AnimalId);
// lists.Add(new MedicationList
// {
// medicationId = medicineli.medicationId,
// MedicineName = medicineli.medicine.MedicineName,
// AnimalCodeName = animalcodename.AnimalCodeName,
// MedicationDate = medicineli.MedicationDate,
// Dose = medicineli.Dose,
// Comments = medicineli.medicine.Comments,
// OperatorName = medicineli.medicine.OperatorName
// });
//}
//admin.medicinelist = lists;
//#endregion
//--------------------------Vaccination ------------------------------
#region
//var availablevaccine = AnimalInformationDBAcces.GetAvailableVaccines();
//if (availablevaccine != null)
//{
// availablevaccine = availablevaccine.Where(a => a.VaccinationDate >= date && a.VaccinationDate <= date1).ToList();
//}
//admin.vaccinelist = availablevaccine;
#endregion
//--------------------------Cow heat ------------------------------
//admin.cowheatlist = AnimalInformationDBAcces.GetHeatListforDateRange(date,date1);
//--------------------------order List ------------------------------
if (orderid != null)
{
AgroExpressDBAccess.UpdateOrder((int)orderid);
}
admin.orderlist = AgroExpressDBAccess.GetAllNotDeliveredOrder();
//--------------------------Product and sale ------------------------------
#region
var milks = AgroExpressDBAccess.GetMilkSummaryByDate(System.DateTime.Now.Date.AddDays(-7), System.DateTime.Now.Date.AddDays(1));
List <ProductandSaleHistory> history = new List <ProductandSaleHistory>();
foreach (var item in milks)
{
if (milks != null)
{
var sale = AgroExpressDBAccess.GetSaleHistoryByDate(item.Date, item.Date.AddDays(1));
double totalsale = 0.0;
if (sale != null)
{
foreach (var milksale in sale)
{
totalsale += milksale.Amount;
}
}
history.Add(new ProductandSaleHistory
{
Date = item.Date,
TotalProduction = item.TotalProduction,
CulfMorning = item.CulfMorning,
CulfAfternoon = item.CulfAfternoon,
Factory = item.Factory,
Stuff = item.Stuff,
Wastage = item.Wastage,
TotalSale = totalsale
});
}
}
admin.productandsale = history;
#endregion
#region
string name = HttpContext.User.Identity.Name;
int id = AgroExpressDBAccess.GetCustomerIdByUserId(name);
if (id != 0)
{
var customer = AgroExpressDBAccess.GetCustomerByID((int)id);
admin.CustomerName = customer.FullName;
if (customer != null)
{
var cus = AgroExpressDBAccess.GetCustomerTransectionHistory(DateTime.Now.AddDays(-30).Date, DateTime.Now.AddDays(1).Date, (int)id);
admin.TransactionHistory = cus;
}
}
#endregion
//----------------Notification----------
var notification = AgroExpressDBAccess.GetNotificationByDate(System.DateTime.Now);
if (notification != null)
{
admin.Notification = notification;
}
return(View(admin));
}