예제 #1
0
        //public IEnumerable<sodmsodEntity> GetAllsodmupdate(int OrderID)
        //{
        //    SqlCommand cmd = new SqlCommand("getSalesDetails");
        //    cmd.CommandType = CommandType.StoredProcedure;
        //    var locMas = _unitOfWork.DbLayer.GetEntityList<sodmsodEntity>(cmd);
        //    return locMas;
        //}

        //public IEnumerable<BusinessEntities.sodmsodEntity> GetStateByCountryId(int CountryId)
        //{
        //    var stateList = _unitOfWork.StateRepository.GetMany(a => a.CountryId == CountryId && a.IsActive == true).ToList();

        //    if (stateList.Any())
        //    {
        //        var config = new MapperConfiguration(cfg =>
        //        {
        //            cfg.CreateMap<Country, CountryEntity>();
        //            cfg.CreateMap<State, StateEntity>();
        //        });

        //        IMapper mapper = config.CreateMapper();
        //        var StateModel = mapper.Map<List<State>, List<sodmsodEntity>>(stateList);
        //        return StateModel;
        //    }
        //    return new List<sodmsodEntity>();
        //}

        public bool Create(sodmsomdEntity obj)
        {
            bool       res = false;
            SqlCommand cmd = new SqlCommand("SP_SODInsert");

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@p_OrderNumber", obj.OrderNumber);
            cmd.Parameters.AddWithValue("@p_CODE", obj.CODE);
            cmd.Parameters.AddWithValue("@p_CustomerID", obj.CustomerID);
            cmd.Parameters.AddWithValue("@p_OrderDate", obj.OrderDate);
            cmd.Parameters.AddWithValue("@p_ACKDate", obj.ACKDate);
            cmd.Parameters.AddWithValue("@p_OrderTakenBy", obj.OrderTakenBy);
            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_OrderDetails", obj.OrderDetails);
            //cmd.Parameters.AddWithValue("@IsActive", obj.IsActive);
            var locMax = _unitOfWork.DbLayer.ExecuteNonQuery(cmd);

            if (locMax != Int32.MaxValue)
            {
                res = true;
            }
            return(res);
        }
예제 #2
0
 public bool Post([FromBody] sodmsomdEntity SodmsomdEntity)
 {
     try
     {
         return(_sodmService.Create(SodmsomdEntity));
     }
     catch (Exception ex)
     {
         throw new ApiDataException(1000, "Category Not Found", HttpStatusCode.NotFound);
     }
 }