コード例 #1
0
        public bool Update(int OrderID, SalesOrderMaster obj)
        {
            bool       res = false;
            SqlCommand cmd = new SqlCommand("SO_spSaveSalesOrder");

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@p_OrderID", obj.OrderID);
            // cmd.Parameters.AddWithValue("@p_CODE", obj.CODE);
            cmd.Parameters.AddWithValue("@p_OrderDate", obj.OrderDate);
            cmd.Parameters.AddWithValue("@p_ACKDate", obj.ACKDate);
            cmd.Parameters.AddWithValue("@p_AssignedTo", obj.AssignedTo);
            cmd.Parameters.AddWithValue("@p_ActionBy ", obj.ActionBy);
            cmd.Parameters.AddWithValue("@p_IsActive", obj.IsActive);
            cmd.Parameters.AddWithValue("@p_CustomerID", obj.CustId);
            cmd.Parameters.AddWithValue("@p_OrderTakenBy", obj.OrderTakenBy);
            cmd.Parameters.AddWithValue("@p_OrderStatus", obj.OrderStatus);
            cmd.Parameters.AddWithValue("@p_OrderDetails", obj.OrderDetails);
            var locMas = _unitOfWork.DbLayer.ExecuteNonQuery(cmd);

            if (locMas != Int32.MaxValue)
            {
                res = true;
            }
            return(res);
        }
コード例 #2
0
 public bool Post(SalesOrderMaster SalesOrderMasterEntity)
 {
     try
     {
         return(_SalesOrderService.Create(SalesOrderMasterEntity));
     }
     catch (Exception ex)
     {
         throw new ApiDataException(1000, "Category Not Found", HttpStatusCode.NotFound);
     }
 }
コード例 #3
0
        public Object SaveSalesOrder(dynamic data)
        {
            SalesOrderMaster salesOrderMaster = JsonConvert.DeserializeObject <SalesOrderMaster>(data.ToString());

            _salesOrderLogic.AddorUpdate(salesOrderMaster);

            return(new
            {
                success = true,
                SalesOrderMaster = new { Record = salesOrderMaster, TotalRecords = 1 },
                SalesOrderDetails = new { Record = salesOrderMaster.SalesOrderDetails, TotalRecords = salesOrderMaster.SalesOrderDetails.Count }
            });
        }
コード例 #4
0
 public bool Put(SalesOrderMaster SalesOrderMaster)
 {
     try
     {
         if (SalesOrderMaster.OrderID > 0)
         {
             return(_SalesOrderService.Update(SalesOrderMaster.OrderID, SalesOrderMaster));
         }
     }
     catch (Exception ex)
     {
         throw new ApiDataException(1000, "Product not found", HttpStatusCode.NotFound);
     }
     return(false);
 }
コード例 #5
0
 public SalesOrderMaster AddorUpdate(SalesOrderMaster master)
 {
     _salesOrderMasterRepository.AddOrUpdate(master);
     _salesOrderMasterRepository.SaveChanges();
     return(master);
 }