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); }