public FSCOrderDetails GetOrderDetails(int FSCId, int RoleId, string fromdate, string todate, int status, string Mode)
{
FSCOrderDetails FSCOrderList = new FSCOrderDetails();
DataSet ds = new VideoCartDal().GetOrderDetails(FSCId, RoleId, fromdate, todate, status, Mode);
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 ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["CreatedDate"]);
//_fscOrd.Deliverydate = ds.Tables[0].Rows[i]["DeliveryInstruction"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["DeliveryInstruction"]);
_fscOrd.Deliverydate =
(ds.Tables[0].Rows[i]["DeliveryInstruction"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(ds.Tables[0].Rows[i]["DeliveryInstruction"])).ToString("dd/MM/yyyy");
_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());
_fscOrd.Status = ds.Tables[0].Rows[i]["Status"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["Status"]);
_FscOList.Add(_fscOrd);
}
FSCOrderList.OrderList = _FscOList;
}
}
return(FSCOrderList);
}
public FSCOrderDetails GetOrderDetailsByFarmerID(string apiKey, int FarmerID, string fromdate, string todate, int status = 0)
{
FSCOrderDetails FSCOrderList = new FSCOrderDetails();
if (apiKey == ConfigurationManager.AppSettings["reasonkey"])
{
try
{
FSCOrderList = _agentbal.GetOrderDetailsByFarmerID(FarmerID, fromdate, todate, status);
}
catch (Exception ex)
{
LogBal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, 0);
}
}
else
{
}
return(FSCOrderList);
}
