public IActionResult InsertOwnershipTransfer(CartonOwnershipTransfer cartonOwnership) { if (_ownershipRepository.InsertOwnership(cartonOwnership)) { return(new JsonErrorResult(new { Message = "Ownership Transfered" }, HttpStatusCode.OK)); } else { return(new JsonErrorResult(new { Message = "Ownership Transfer Failed" }, HttpStatusCode.NotFound)); } }
public bool InsertOwnership(CartonOwnershipTransfer cartonOwnership) { List <SqlParameter> parms = new List <SqlParameter> { new SqlParameter { ParameterName = CartonOwnershipTransferStoredProcedure.StoredProcedureParameters[0].ToString(), Value = cartonOwnership.FromCartonNo.AsDbValue() }, new SqlParameter { ParameterName = CartonOwnershipTransferStoredProcedure.StoredProcedureParameters[1].ToString(), Value = cartonOwnership.ToCartonNo.AsDbValue() }, new SqlParameter { ParameterName = CartonOwnershipTransferStoredProcedure.StoredProcedureParameters[2].ToString(), Value = cartonOwnership.SearchBy.AsDbValue() }, new SqlParameter { ParameterName = CartonOwnershipTransferStoredProcedure.StoredProcedureParameters[3].ToString(), Value = cartonOwnership.ToCustomerCode.AsDbValue() }, new SqlParameter { ParameterName = CartonOwnershipTransferStoredProcedure.StoredProcedureParameters[4].ToString(), Value = cartonOwnership.UserId.AsDbValue() } }; return(_tcContext.Set <BoolReturn>().FromSqlRaw(CartonOwnershipTransferStoredProcedure.Sql, parms.ToArray()).AsEnumerable().First().Value); }