private static BookedOrder ToBookedOrder(Order order) =>
BookedOrder.Available(
order.Id,
order.OrderNumber,
order.TotalPrice,
order.Draft.Items.Select(ToBookedItem).ToArray()
);
public void AddOrder(object target, object source, IDropInfo dropInfo)
{
Console.WriteLine("AddOrder");
//ObservableCollection<Models.Task> tasks = dropInfo.TargetCollection as ObservableCollection<Models.Task>;
ScheduleTasks tasks = null;
BookedOrder order = source as BookedOrder;
DateTime start = Start;
if (tasks.Count > 0)
{
start = tasks.Last().End.AddMinutes(1);
}
var procTime = order.BookQty / order.WPD;
DateTime end = Start.AddDays((double)procTime);
ScheduleTask task = new ScheduleTask()
{
Description = String.Format("{0} {1}",
order.CustShortName,
order.CustSpecNickName,
order.OrdNum,
order.OrdItem),
Start = start,
End = end
};
tasks.Add(task);
}
public BookedOrderViewModel Create(BookedOrder order)
{
BookedOrderViewModel vm = this.resolutionRoot.Get <BookedOrderViewModel>();
Mapper.Map <BookedOrder, BookedOrderViewModel>(order, vm);
vm.Lots.AddRange(order.Lots);
ViewModels.Add(order.BookedOrderID, vm);
return(vm);
}
BookedOrderViewModel IBookedOrderViewModelFactory.Create(BookedOrder order)
{
return(this.Create(order));
}
public SathiOrderDetails GetSathiSalesReport(string apikey, int UserId, int DateMode, DateTime?SDATE, DateTime?EDATE)
{
SathiOrderDetails _sathiOrderDetails = new SathiOrderDetails();
SathiOrderDetail _objData = new SathiOrderDetail();
List <FarmerOrderDetails> _objFarmerDataList = new List <FarmerOrderDetails>();
List <FarmerOrderDetails> _objFarmerCancellDataList = new List <FarmerOrderDetails>();
List <FarmerOrderDetails> _objFarmerDeliveredDataList = new List <FarmerOrderDetails>();
BZOfferBanner ObjOfferBanner = new BZOfferBanner();
BookedOrder _bookedOrder = new BookedOrder();
DeliveredOrder _deliveredOrder = new DeliveredOrder();
CancelledOrder _cancelledOrder = new CancelledOrder();
DataSet ds = new SathiOrderDetailsDal().GetSathiSalesReport(apikey, UserId, DateMode, SDATE, EDATE);
if (ds != null && ds.Tables.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
_objData.SathiName = ds.Tables[0].Rows[i]["SathiName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["SathiName"]);
_objData.ValueIncentive = ds.Tables[0].Rows[i]["ValueIncentive"] == DBNull.Value ? 0 : Convert.ToDecimal(ds.Tables[0].Rows[i]["ValueIncentive"]);
_objData.OrderIncentive = ds.Tables[0].Rows[i]["OrderIncentive"] == DBNull.Value ? 0 : Convert.ToDecimal(ds.Tables[0].Rows[i]["OrderIncentive"]);
_objData.TotalIncentive = ds.Tables[0].Rows[i]["TotalIncentive"] == DBNull.Value ? 0 : Convert.ToDecimal(ds.Tables[0].Rows[i]["TotalIncentive"]);
_bookedOrder.BookedQuantity = ds.Tables[0].Rows[i]["BookedQuantity"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["BookedQuantity"]);
_bookedOrder.BookedValue = ds.Tables[0].Rows[i]["BookedValue"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["BookedValue"]);
_bookedOrder.FarmerOrderDetails = new List <FarmerOrderDetails>();
_deliveredOrder.DelieveredQuantity = ds.Tables[0].Rows[i]["DelieveredQuantity"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["DelieveredQuantity"]);
_deliveredOrder.DeliveredValue = ds.Tables[0].Rows[i]["DelieveredValue"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["DelieveredValue"]);
_deliveredOrder.FarmerOrderDetails = new List <FarmerOrderDetails>();
_cancelledOrder.CancelledQuantity = ds.Tables[0].Rows[i]["CancelledQuantity"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["CancelledQuantity"]);
_cancelledOrder.CancelledValue = ds.Tables[0].Rows[i]["CancelledValue"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["CancelledValue"]);
_cancelledOrder.FarmerOrderDetails = new List <FarmerOrderDetails>();
}
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
FarmerOrderDetails _objFarmerData = new FarmerOrderDetails();
_objFarmerData.FarmerId = ds.Tables[1].Rows[i]["FarmerId"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[1].Rows[i]["FarmerId"]);
_objFarmerData.FarmerName = ds.Tables[1].Rows[i]["FarmerName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[1].Rows[i]["FarmerName"]);
_objFarmerData.FatherName = ds.Tables[1].Rows[i]["FatherName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[1].Rows[i]["FatherName"]);
_objFarmerData.Village = ds.Tables[1].Rows[i]["Village"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[1].Rows[i]["Village"]);
_objFarmerData.Block = ds.Tables[1].Rows[i]["Block"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[1].Rows[i]["Block"]);
_objFarmerData.State = ds.Tables[1].Rows[i]["State"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[1].Rows[i]["State"]);
_objFarmerData.orderId = ds.Tables[1].Rows[i]["orderId"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[1].Rows[i]["orderId"]);
_objFarmerData.ProductName = ds.Tables[1].Rows[i]["ProductName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[1].Rows[i]["ProductName"]);
_objFarmerData.Quantity = ds.Tables[1].Rows[i]["Quantity"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[1].Rows[i]["Quantity"]);
_objFarmerData.DelieveredAmount = ds.Tables[1].Rows[i]["DelieveredAmount"] == DBNull.Value ? 0 : Convert.ToDecimal(ds.Tables[1].Rows[i]["DelieveredAmount"]);
_objFarmerData.DeliveryDate = ds.Tables[1].Rows[i]["DeliveryDate"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[1].Rows[i]["DeliveryDate"]).Substring(0, 10);
_objFarmerData.DeliveryDate = (_objFarmerData.DeliveryDate.Trim().Split('/')[1] + "/" + _objFarmerData.DeliveryDate.Trim().Split('/')[0] + "/" + _objFarmerData.DeliveryDate.Trim().Split('/')[2]);
_objFarmerData.PaymentStatus = Convert.ToInt32(ds.Tables[1].Rows[i]["OrderStatus"]) == 0 ? false : Convert.ToInt32(ds.Tables[1].Rows[i]["OrderStatus"]) == 2?false: true;
_objFarmerData.District = ds.Tables[1].Rows[i]["District"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[1].Rows[i]["District"]);
_objFarmerDataList.Add(_objFarmerData);
if (ds.Tables[1].Rows[i]["OrderStatus"].ToString() == "2")
{
_objFarmerCancellDataList.Add(_objFarmerData);
}
if (ds.Tables[1].Rows[i]["OrderStatus"].ToString() == "5")
{
_objFarmerDeliveredDataList.Add(_objFarmerData);
}
}
_sathiOrderDetails.SathiOrderDetail = _objData;
_sathiOrderDetails.SathiOrderDetail.BookedOrder = _bookedOrder;
_sathiOrderDetails.SathiOrderDetail.DeliveredOrder = _deliveredOrder;
_sathiOrderDetails.SathiOrderDetail.CancelledOrder = _cancelledOrder;
_sathiOrderDetails.SathiOrderDetail.BookedOrder.FarmerOrderDetails = _objFarmerDataList;
_sathiOrderDetails.SathiOrderDetail.DeliveredOrder.FarmerOrderDetails = _objFarmerDeliveredDataList;
_sathiOrderDetails.SathiOrderDetail.CancelledOrder.FarmerOrderDetails = _objFarmerCancellDataList;
}
return(_sathiOrderDetails);
}
