public FSCOrderDetails GetOrderDetailsByFarmerID(int FarmerID, string fromdate, string todate, int status)
{
FSCOrderDetails FSCOrderList = new FSCOrderDetails();
DataSet ds = new AgentAppDal().GetOrderDetailsByFarmerID(FarmerID, fromdate, todate, status);
if (ds != null && ds.Tables.Count > 0)
{
{
List <FSCOrderList> _FscOList = new List <FSCOrderList>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
FSCOrderList _fscOrd = new FSCOrderList();
_fscOrd.OrderId = ds.Tables[0].Rows[i]["OrderID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["OrderID"].ToString());
_fscOrd.OrderRefNo = ds.Tables[0].Rows[i]["OrderRefNo"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["OrderRefNo"]);
_fscOrd.FarmerName = ds.Tables[0].Rows[i]["FarmerName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["FarmerName"]);
_fscOrd.CreateDate = (ds.Tables[0].Rows[i]["CreatedDate"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(ds.Tables[0].Rows[i]["CreatedDate"])).ToString("dd/MM/yyyy").Replace('-', '/');
_fscOrd.Deliverydate =
(ds.Tables[0].Rows[i]["DeliveryInstruction"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(ds.Tables[0].Rows[i]["DeliveryInstruction"])).ToString("dd/MM/yyyy").Replace('-', '/');
_fscOrd.TotalPrice = ds.Tables[0].Rows[i]["OrderAmt"] == DBNull.Value ? 0 : Convert.ToDecimal(ds.Tables[0].Rows[i]["OrderAmt"]);
_fscOrd.OrderStatus = ds.Tables[0].Rows[i]["OrderStatus"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["OrderStatus"].ToString());
_FscOList.Add(_fscOrd);
}
FSCOrderList.OrderList = _FscOList;
}
}
return(FSCOrderList);
}
public ApplyPromoCoupon ApplyCoupon(int CatID, int SubCatID, int CompanyID, int BrandID, int ProductID, int PkgID, int Qty, decimal ActualAmt, int CouponID)
{
DataSet ds = new AgentAppDal().ApplyCoupon(CatID, SubCatID, CompanyID, BrandID, ProductID, PkgID, Qty, ActualAmt, CouponID);
ApplyPromoCoupon _ApplyPromoCoupon = new ApplyPromoCoupon();
if (ds != null)
{
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
_ApplyPromoCoupon = ds.Tables[0].AsEnumerable().Select(a => new ApplyPromoCoupon
{
ActualAmt = a.Field <decimal>("ActualAmt"),
BrandID = a.Field <int>("BrandID"),
CatID = a.Field <int>("CatID"),
CompanyID = a.Field <int>("CompanyID"),
CouponCode = a.Field <string>("CouponCode"),
CouponID = a.Field <int>("CouponID"),
DiscAmount = a.Field <decimal>("DiscAmount"),
DiscType = a.Field <Int16>("DiscType"),
FinalAmount = a.Field <decimal>("SubTotal"),
PkgID = a.Field <int>("PkgID"),
ProductID = a.Field <int>("ProductID"),
Qty = a.Field <int>("Qty"),
SubCatID = a.Field <int>("SubCatID"),
CouponMsg = a.Field <string>("MSG"),
CouponStatus = a.Field <int>("CouponStatus")
}).FirstOrDefault();
}
}
return(_ApplyPromoCoupon);
}
