Example #1
0
        public List <SalesordersBOL> LoadSalesOrdersData(SalesordersBOL obj)
        {
            DataSet               dsSalesOrder      = objBll.Select(obj);
            SalesordersBOL        objSO             = new SalesordersBOL();
            List <SalesordersBOL> lstSalesordersBOL = new List <SalesordersBOL>();

            if (dsSalesOrder != null && dsSalesOrder.Tables[0] != null && dsSalesOrder.Tables[0].Rows.Count > 0)
            {
                foreach (DataRow dr in dsSalesOrder.Tables[0].Rows)
                {
                    objSO              = new SalesordersBOL();
                    objSO.CustomerID   = Convert.ToString(dr["CustomerID"]);
                    objSO.EmployeeID   = Convert.ToInt32(dr["EmployeeID"]);
                    objSO.OrderDate    = Convert.ToDateTime(dr["OrderDate"]);
                    objSO.RequiredDate = Convert.ToDateTime(dr["RequiredDate"]);
                    objSO.SalesOrderID = Convert.ToInt32(dr["SalesOrderID"]);
                    objSO.ShipAddress  = Convert.ToString(dr["ShipAddress"]);
                    objSO.ShipCity     = Convert.ToString(dr["ShipCity"]);
                    objSO.ShipCountry  = Convert.ToString(dr["ShipCountry"]);
                    objSO.ShipName     = Convert.ToString(dr["ShipName"]);
                    lstSalesordersBOL.Add(objSO);
                }
            }
            return(lstSalesordersBOL);
        }
Example #2
0
 public DataSet SelectCashReport(SalesordersBOL obj)
 {
     try
     {
         DataSet ds = objBll.SelectCashReport(obj);
         return(ds);
     }
     catch
     {
     }
     return(null);
 }
Example #3
0
 public bool Delete(SalesordersBOL obj)
 {
     if (obj != null)
     {
         try
         {
             int retVal = objBll.Delete(obj);
             if (retVal > 0)
             {
                 return(true);
             }
         }
         catch
         {
             return(false);
         }
     }
     return(false);
 }
Example #4
0
 public int Insert(SalesordersBOL obj)
 {
     if (obj != null)
     {
         try
         {
             int retVal = objBll.Insert(obj);
             if (retVal > 0)
             {
                 return(retVal);
             }
         }
         catch
         {
             return(0);
         }
     }
     return(0);
 }